Access the answers to your technology questions today.
Subscribe Now
30-day free trial. Register in 60 seconds.
What Makes Experts Exchange Unique?
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
Subscribe Now
30-day free trial. Register in 60 seconds.
Join the Community
Give a Little. Get a Lot.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Join the Community
by: LSMConsultingPosted on 2009-10-06 at 10:55:39ID: 25507799
You'd have to close the query, then reopen it. Unfortunately, you cannot work with queries in this manner via code, which is why you should NOT show queries to the end user in this fashion. Queries should be used ONLY to build forms/reports, and should not be exposed to the end user.
ourFormNam e").IsLoad ed Then DoCmd.Close acForm, "YOurFormName")
ectID ... the argument in the OpenForm method will filter the form correctly.
So: Build 3 forms, one for each of those queries, then change your code like this:
Private Sub SearchIntake_Click()
If CurrentPRoject.AllForms("Y
DoCmd.OpenForm "YourFormName", , , "ProjectID=" & Me.cboProjectID
End Sub
In your queries, REMOVE the criteria that looks at _SearchByProjectID.cboProj