Using 2 recordsources on 1 form

[Casey]

Hi,
Im trying to use 2 recordsources on one form. Im not sure if this is possible. I have 2 linked tables that Id like to show the fields from on one form. I can select one or the other on the forms properties, but Im not sure how to do both. Can I use a semicolon or something like that to list all the fields. Id rather not have to use a query, and bring the tables together. Because then when I update the form itll update the query (I think) not the tables. Any suggestions?
thanks
Casey

 

[Mudface]

If your tables are related 1 to Many, then you can use a Subform within your main form for the many side records. The Form Wizard will actually do this for you, if you select the fields from more than one table (or a query joining the two tables) linked 1 to Many. When you update the records on the form, the underlying tables are updated too- a query doesn't actually contain any records, it just retrieves records from it's underlying table(s).

 

[Casey]

Thank you I didn know about the query thatll work just fine
Casey