Form Open

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?
 
A

Arvin Meyer MVP

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

filtering a form based on the values of a subform 0
Form/Subform 5
Trick filter form combo with DoCmd.OpenForm and Data Entry property 2
Form Opens to record if Like 4
code to open blank form activates code to show record has changed 2
Populate combo box with record data when record is pulled by another combo box 3
Dropdown list in a form to filter another form before it opens 2
Repost from 6/18: New record in subform for info on main form 2

Top