multiple table form?

hi there

Registered User.
Local time
Today, 14:55
Joined
Sep 5, 2002
Messages
171
hey all,

i was wondering if it's possible to create a tabbed input form with each tab populating a different table, however the tables are not related? for example, one tab would be for deposits/withdraws information and the second tab would be for bill payment information. Any comments or suggestions are greatly appreciated.

thanks
 
Sounds like you need to create an update query. Open a new query in design view and then add the tables you want to relate to each other. Draw relationship lines and save the query. Then open the query tool and select Update Query and enter the criteria using expressions or selecting preset fields. Good luck.

Marty
 
On each tab page, place a subform bound to the appropriate table.

Dave
 

Users who are viewing this thread

Back
Top Bottom