One form, two tables

[kupe]

Links to a number of queries are on a form which has as its source tblA. I want to get a few other queries working that filter tblB.

I believe this is the cause of the trouble that has stymied me for hours and hours on

http://www.access-programmers.co.uk/forums/newreply.php?action=newreply&threadid=56693

Do I declare something like tblA and tblB in the form's RecordSource, please Experts?

 

[Michelangelo]

I don't think it is possible to link 1 form to more than one table. however U could use subforms, and link each subform to a different table.

HTH.

M.

 

[kupe]

Thanks, Michelangelo, but of course I don't want to do that. I'm sure there's a way I did this recently, only I can't recall how. I appreciate your help. Cheers