isladogs
MVP / VIP
- Local time
- Today, 16:47
- Joined
- Jan 14, 2017
- Messages
- 18,949
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.
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.