Add New Table to a Form

[cinrod]

I have form that is using tab controls. I want each tab to have fields from a specific table on it. When I go to the 2nd tab, how do I change the table so I can put those fields in it? I haven't been able to figure this one out.

Thanks in advance!

 

[PHV]

Use a different SubForm in each tab.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[c2rich]

Hey cinrod:

You could use a different sub form in each tab, or if you are willing to do so, create a query with all the tables and fields from each and populate them this way. Be careful when do this though if you have information that relates to another table make sure to add the necessary field so that all information is updated

-Kerry

Those that know, do. Those that understand, teach. -Aristotle

 

[cinrod]

Thanks for the help guys! I've never tried the subforms but I have notes on how to do it. I'll give it a try!