Form Open

[SunflowerdBGirl]

I have a form that opens based upon the selection made by the user. If the
user selects a particular project it is supposed to open data only for that
project. If no data currently exists for that project I need it to open the
form with a blank record so that the user can enter new data. Can anyone help?

 

[Arvin Meyer MVP]

I have a form that opens based upon the selection made by the user. If the
user selects a particular project it is supposed to open data only for
that
project. If no data currently exists for that project I need it to open
the
form with a blank record so that the user can enter new data. Can anyone
help?

Assuming there is a ProjectID in a combo or list box use something like:

Sub lstProjects_AfterUpdate()
DoCmd.OpenForm "frmProjects",,,"ProjectID =" & Me.lstProjects
End Sub