Subject: DoCmd.OpenForm
Posted By: turp Post Date: 12/14/2006 3:12:56 PM
All I'm attempting to do is open an existing form using a click from another.

DoCmd.OpenForm "frm_GSG_Access_Rights", , ,

I don't want to filter out any records from the subsequent form, is there a way to wildcard the where clause?

- Turp
Reply By: leehambly Reply Date: 12/15/2006 4:23:20 AM
Just ignore it
Reply By: mmcdonal Reply Date: 12/15/2006 7:33:15 AM
Is there a filter already applied to the second form? If there is not, the statement you posted will not filter the second form. You can remove the following commas, so your statement reads:

DoCmd.OpenForm "frm_GSG_Access_Rights"

HTH

mmcdonal

Go to topic 52714

Return to index page 92
Return to index page 91
Return to index page 90
Return to index page 89
Return to index page 88
Return to index page 87
Return to index page 86
Return to index page 85
Return to index page 84
Return to index page 83