Data on form not saved fast enough for display on report

[swee]

I have a purchase order form that has a subform embedded. After users have filled up the form, they click on a button that will open up a print preview of a report. The report shows the details of the form they entered. However, all the fields on the parent form that are filled up after filling up the subform are not displayed on the report.

The reason is most probably that they have not been saved yet. How can I solve this problem?

Regards,
Swee

 

[Oldsoftboss]

The cmdbutton will have code like

DoCmd.OpenReport "rptName"

put

DoCmd.RunCommand accmdSaveRecord

before this line.

Dave

 

[swee]

The cmdbutton will have code like

DoCmd.OpenReport "rptName"

put

DoCmd.RunCommand accmdSaveRecord

before this line.

Dave

It displays the fields on the report now, but there's a write conflict when I click the cmdbutton. It says that the record has been saved and I will be saving it again. How can I get rid of that messagebox?

 

[Rich]

Why would you fill in the Parent form after the SubForm?

 

[swee]

I set the form's property to be Edited Record. The write conflict message is no longer prompted. Thanks for everyone's time