Form Open

  • Thread starter Thread starter SunflowerdBGirl
  • Start date Start date
S

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?
 
SunflowerdBGirl said:
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?
Click to expand...

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
 
Back
Top