Append Query and prompts 1

[paulfla]

I have an append query where I want to set two columns with the same user entered data. I places data from one table into another.

When the query runs it ask the user to "Enter The Client ID". This entered data should be contained in all the rows of "Column A" and "Column D". Below is what is contained in the "Field" box of Column A (In the query Design View):

Client: [Enter 4 Character Client Code]

I know I can place the same thing for Column D, but I want the user to only enter the data once.

Thanks in advance for your help.

 

[Steve101]

If you repeat the [Enter 4 Character Client Code] exactly prompt against the second field, I would have thought you'd only get the one prompt.

Alternatively, after you're run the append query once, you can apply a second update query to copy the first column v alue to the next.

Its not clear from your initial post, but if this is all happening through a user interface (ie. a form with a button on it to initiate the query), then you can prompt for the name via the form (maybe even using a combo or list box), then use the control reference as the parameter.

For example, if your form is called frmYourForm, and the control is called txtSomeonesName, then you could enter in the query:

Forms!frmYourForm!txtSomeonesName

Your user then enters the persons name on the form, presses the button; no further prompts after the button press; it all happens 'beneath the bonnet' from there.



Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)

 

[paulfla]

Steve:

Thank you! By making the second text for the prompt exactly like the first one, I only had to enter it in once.

Thanks for the Help. You all are great!!!!

Paul