Does anyone know how to write a macro or queries that I can add to a button to simultaneously add new record to all tabbed forms in my navigation panel? I have 6 forms. I just want one button on first form that would accomplish this task.
Queries Macro
- Thread starter WES9659
- Start date
John Big Booty
AWF VIP
- Local time
- Tomorrow, 07:55
- Joined
- Aug 29, 2005
- Messages
- 8,243
What is the nature of the data you wish to add? How many underlying tables are we talking about?
Thank you for trying to help me. Ok let me see if I can explain my dilemma. I have attached a zip file of data base so hopefully someone can see what I am doing wrong. Under my forms tab I have created a Navigation Form which allows me to tab thru my other forms. The first tabbed form you will see is the Basic Demographics Tab on that specific tab I have added 3 buttons one is a Save Record button, Add Record button and a Delete Record Button. Both Save Record and Delete Record Saves and deletes records on each of the tabs simultaneously like I want. However the Add Record button only works on the Basic Demographics form that it resides on. How can I make it work on all the tabs at once that are included in the Navigation Form? FYI You must add something in Client ID like WR456 to save record. Do I have to do this with queries? Thanks everyone for all your help and consideration.
