Query Retrieval From Form

I'm still baffled by what you are asking

If you add a new record on the form it is automatically saved to the table and can then be viewed in the query

You can create a report showing either all records or filter for the record shown on the form

You can also add a button to the form to open the report - again either all records or filtered for the current record.

By all means use VBA to add suitable code if you understand what you are doing.
However, you can also using wizards provided by Access to do much of the initial work for you.

May I suggest you look at some of the many access videos by Steve Bishop available on You Tube.
They form a complete course over 100+ videos from beginners to advanced & are well worth investing time in.
 
What I'm doing is using a form for a survey. After the user answers the last question on the form (survey), press a button, his/her record is saved to a table that has all records (individual's responses). I want to capture the firstname, middlename, and lastname on the form and pass it to a query to select ONLY their survey answers in a report. Once, it's save to the table that has all records, I have no way (that I know of) to get this person's information that just completed the survey. I hope this answers any questions that is unanswered, if not, I'll try again. Thanks ! ! !
 

Users who are viewing this thread

Back
Top Bottom