Try using a sub-form.
Guy Harley www.youramigo.com _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of rlee_at_channing Sent: Wednesday, 8 November 2006 10:54 AM To: [email protected] Subject: [ms_access] CAN AN ACCESS FORM HAVE MORE THAN ONE DATA SOURCE? I'm in a bit of a quandry here. I built this form containing 250 or so fields all from one data source. The person I'm working for wanted to add another 100 or so fields to the form so I had to build a new table to house the 100 new fields. But when I went back to the form to see if I could add the new fields from the new table, I got stuck. Is there a way to add fields from another data source to the form? Regards, Ryan [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ms_access/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
