Query Help

[xeb]

Hi:

I've researched the append query, update query, etc. but can't seem to find my answer. Maybe I'm on the wrong track entirely.

Is there a way for a user to enter information into a query that retrieves the desired record which is then displayed on a form but that also puts the information they entered into a table.

In other words this is how it works now...

The user clicks on the form "Check My Codes" and the query prompts them for their name and their code number. Their name, code number, and their prize (which is part of the record in the table) displays on the form.

What I want to do is avoid having them print out the form and submit it to get their prize. I'd like the name they entered to end up in the table (or a table) along with the other information so we can then simply review the table and award the prizes without using so much ink and paper to print the forms.

Thanks,

xeb

 

[DocNice]

I'm having a little bit of trouble following your question, but I'll try. First, when you pull up a query, you can edit it straight from the screen. If that query is based on a table and you have set up your relationships, you should be able to just type in the missing information and it will fill the corresponding table.

If you need to base the query on information they input, that can be done by placing a control name in [brackets] in the criteria section of the query which refers to the control in which they enter information.

 

[xeb]

Thanks for answering.

At the present time my users (who want to find out if they won) click on the "Check My Codes" form. This starts a query that prompts them for their name and code number. Once they enter that information the form opens with their name, code number, and prize. They print the form and submit it to claim their prize. This works fine. However, what I want to do is "capture" their name and store it beside the code they entered in the table or another table so I can then review the table and award prizes without them printing out and submitting the form.

Thanks,

xeb