save text input (comments) to view in report

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

Guest

I have a form with a subform. The user inputs data in the main form and when
the user clicks on the subfom, he is asked to save the record. After
inputting data on the subform the user would click "Referral form" to view
all the information entered in both forms in a report. Now, I have added a
comment text box. This belongs to main form but is available for input after
the user has entered data in the subform. Now when the user clicks "Referral
Form" the comments are not there unless the user goes to File --> Save. Is
there anyway of updating the Comments on the main form and view the comments
in the Referral Form without going to File --> Save?

thanks for any kind of help!
 
I assume "Referral Form" is a Command Button, or some such? And I
assume it is on the main form, not on the subform, am I right? On the
Click event of "Referral Form", I assume there is a macro or a VBA
procedure assigned, which opens the report. Into this macro or VBA
procedure, try including an explicit save of the main form's data,
before the OpenReport. In a macro, you would use the RunCommand action,
with the Command argument SaveRecord. In a VBA procedure, you would use
DoCmd.RunCommand acCmdSaveRecord
 
That worked! thank you so much!

Steve Schapel said:
I assume "Referral Form" is a Command Button, or some such? And I
assume it is on the main form, not on the subform, am I right? On the
Click event of "Referral Form", I assume there is a macro or a VBA
procedure assigned, which opens the report. Into this macro or VBA
procedure, try including an explicit save of the main form's data,
before the OpenReport. In a macro, you would use the RunCommand action,
with the Command argument SaveRecord. In a VBA procedure, you would use
DoCmd.RunCommand acCmdSaveRecord
Click to expand...
 
Back
Top