Open report from data entry form

[pbuecken]

I have a form where the user enters data. When he is finished entering the data i want the user to press a button that stores the record and opens the report nonpaying the just entered record. I was looking at the Docmd.Openreport command but are unsure how to get the where condition sorted?



I am fairly new in access 2010.

Appreciate any help.

[pbaldy]

This should help:

http://www.baldyweb.com/wherecondition.htm

[ss2020]

I have a question along this same line. This part works fine, but sometimes in the 2nd form there is no corresponding record and the form is blank and dead when it comes up. I would like it to look at the 2nd form and if the record does not exist create one. I have been reading but can't find out how this is done.

[pbaldy]

For a report you can just use the no data event. For a form, you can test using a DCount with the same criteria. If > 0, open with the wherecondition, otherwise open to a new record.

[pbuecken]

Thanks pbaldy that did the trick.

[pbaldy]

Happy to help!