Updating a table from Form Entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that pops up when a user clicks a button to Print said form.
The form is for the user to enter the name of the table and any footnotes for
that particular form, this form is connected to a table that stores this
information for everytime the report is printed. THe problem I having is that
when the user enters the information and clicks [PRINT] the report is blank,
when I open the table the info the user has entered has not updated onto the
table yet. Is there a way so that when the user clicks [PRINT] the footnote
table will update BEFORE the report prints?

Larry
 
I have a form that pops up when a user clicks a button to Print said form.
The form is for the user to enter the name of the table and any footnotes for
that particular form, this form is connected to a table that stores this
information for everytime the report is printed. THe problem I having is that
when the user enters the information and clicks [PRINT] the report is blank,
when I open the table the info the user has entered has not updated onto the
table yet. Is there a way so that when the user clicks [PRINT] the footnote
table will update BEFORE the report prints?

Larry
Click to expand...

did you try Me.Dirty=False before printing to force the save to occur
before the printing begins?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

New Record 4
Update on a table 2
How to Print a Subreport from a filtered search 1
Access Access Report Works on One Machine but not Another 3
Excel VBA - Problem with Closing Print Preview 0
Inserting a footnote into Word doc from Access 1
Issue with adding a footnote into automated document from Access 2
Access Sorting and grouping using multiple tables 0

Back
Top