Ryan, You can gain maximum flexibility by not binding the form to any data source. Then via VBA you can issue any SQL commands you want. Alterantively you could initially bind the form to a query and modify the query anyway you want. I assume the table in the original form is somehow related to the table that you are adding, so the query could be a join. Dick
--- In [email protected], "rlee_at_channing" <[EMAIL PROTECTED]> wrote: > > 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 > 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/
