SAVE NEW RECORD COMMAND

[grendal]

I've just created a new entry into my form. When I select my command button to print preview this particular entry, my report opens, but does not contain my new data. As this command works O.K. for existing data, I assume I need to update the form somehow. My existing command is as follows:-

DoCmd.RunCommand acCmdSaveRecord
Dim strDocName As String
Dim strWhere As String
strDocName = "Customer Referral"
strWhere = "[Document Number]=" & Me.Document_Number
DoCmd.OpenReport strDocName, acPreview, , strWhere

Any suggestions?



Cheers s-)
Does the body rule the mind or does the mind rule the body - I dunno!

 

[hymn]

DoCmd.RunCommand acCmdSaveRecord
Should be on the Form
You can place it on the button that opens the report

Hope this helps
Hymn