A series of append queries where user has to enter the same number for each to run

[pbDudley]

Hello
I have a series of append queries that I created a macro for, then I convert this to VB.
So I have a series of append queries written as:

DoCmd.OpenQuery "Qry_Append1" , acViewNormal, acEdit
DoCmd.OpenQuery "Qry_Append2" , acViewNormal, acEdit
DoCmd.OpenQuery "Qry_Append3" , acViewNormal, acEdit
DoCmd.OpenQuery "Qry_Append4" , acViewNormal, acEdit

This works fine with VB, but it prompts the user each time to enter the unique record, plan number, for each of the 4 append queries


It also gives the: You are about to run an append query to ...
Isnt there a way to enter this plan ID once and to turn off the: about to run an append query menus?

Im not the best programmer, I just got the forms and queries to work properly, technically it works as is but Im certain there is a way to do this

Thank you

[June7]

Have queries reference a textbox or combobox on form for user input.

Exactly what does the Enter Plan Number button do?

DoCmd.SetWarnings False
'run queries
...
DoCmd.SetWarnings True

[Micron]

IMHO if you turn off warnings your procedure should include an error handler that turns them back on. That, or use .Execute method of the database object.
When I see multiple objects with similar names I suspect they are just minor variations of the same thing. If they are, one object used in several ways helps keep db size down and reduce re-design work when changes are made.

[pbDudley]

The enter plan button opens a form that all of the append data will be on with additional data that has to be manually entered after the append queries are run

Ill try the text box method with the set warnings line