First off, let me start by saying I'm very new to Access and this is the first real database I've tried to create, so any info you can provide is much appreciated. I created a form where you input a few fields that writes to a table. I also have a button that is supposed to run a query (uses the table I created linked to another to get additional info) to populate a report. When I put in a new record and hit the button, the report does not populate, however if I close out of the form and go back in, it does populate. I know the table I created does populate with the new record and the query and report work by themselves--so why is the report not populating without closing out of the form and going back in? I am far from being a programmer, so if you can explain this without going into VB code that would be wonderful. Thanks for your help!
Report not showing new records
- Thread starter cmf2112
- Start date
neileg
AWF VIP
- Local time
- Today, 18:46
- Joined
- Dec 4, 2002
- Messages
- 5,970
Just to add to Dennisk's answer:
When you enter data in a form it stays in the form and not the table. You need to trigger a Save to write the data to the table. This can happen in several ways. One is to close the form, another is to move to another record, another is to explicitly save the record.
When you enter data in a form it stays in the form and not the table. You need to trigger a Save to write the data to the table. This can happen in several ways. One is to close the form, another is to move to another record, another is to explicitly save the record.
