Form won't filter unles opened as acDialog

  • Thread starter dustinw101 via AccessMonster.com
  • Start date
D

dustinw101 via AccessMonster.com

I have a form that opens to a selected record based on a choice that the user
selects from a list box. The code workes fine with the filter as long as the
opening arguments are set to open the form as a Dialog. If I get rid of this
(which I can't do because I need to put code in the On Activate and On
Deactivate events of the form) the form won't open to the filtered record, it
opens to the first record in the table.

Sample:
DoCmd.OpenForm "frmLeadTracker_OpportunityEntry", acNormal, , sWhere, ,
acDialog (works and filters)

DoCmd.OpenForm "frmLeadTracker_OpportunityEntry", acNormal, , sWhere (opens
form to the first record in the table, ignores the filter)


Any suggestions with be helpful.
 

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

Dynamic Naming of Form Button 3
Insert CLientID into popup form 1
Trick filter form combo with DoCmd.OpenForm and Data Entry property 1
filtering a form based on a filter on an open form 2
Remove Filter before Search 1
What is wrong with this code? 4
DLookup in Continuous form 0
Is this possible? 0

Top