append delete query

[Guest]

i wrote an append and a delete query for a table to move and delete records
by looking up the name field in a record by the statement like 'Enter Name".
i combined the two queries into a macro. i am looking for a way to only type
in the name one time to run both queries on the macro. as it is now, i have
to type the name in twice, once for each query. any help would be greatly
appreciated.

joe

 

[Steve Schapel]

Joe,

Put an unbound textbox on a form, and enter the criteria in here. In
both the Append Query and Delete Query, replace the existing parameter
prompt with a reference to the textbox, using syntax such as...
[Forms]![NameOfForm]![NameOfTextbox]

By the way, as an aside, 'name' is a Reserved Word (i.e. has a special
meaning) in Access, and as such should not be used as the name of a
field or control. I recommend you change this.