docmd.openform help

[Tee2]

My code seems to ignore the WHERE condition when it initially opens the form but if I run it a second time with the form already open the filter is applied. Just seeking advice on what property on the form could be blocking this from working properly because in a simplified database I tested this in it worked.

Example:

 docmd.openform "formname", , , "[ID] = " & sID

Thanks!

 

[Ranman256]

if you dont want the filter dont use the key,

if sID ="" then
    docmd.openform "formname"
else
  docmd.openform "formname", , , "[ID] = " & sID
endif

 

[GinaWhipp]

When you initially open? Are you opening via a Control Action or are you putting that in the On_Event of the Form? The latter will not work...

 

[Tee2]

When you initially open? Are you opening via a Control Action or are you putting that in the On_Event of the Form? The latter will not work...

It is being called from a button on a separate form.

if you dont want the filter dont use the key,

I do want the filter but it is not being applied. I am assuming there is a form property barring it from working because this works on a trial database I tested it on.

 

[GinaWhipp]

If you are opening from a button it should work. Check the Form Properties and make sure it's set to Allow Filters.

 

[Tee2]

If you are opening from a button it should work. Check the Form Properties and make sure it's set to Allow Filters.

Yep, I checked that already and if they weren't allowed it should block it even on the 2nd attempt. I don't understand why it isn't working but it should work another way by just doing...

forms("formname").filter = "[ID] = " & sID
forms("formname").filteron = true

Sorry, I should have thought of that before posting but I was stuck on figuring out why that wasn't working! Thanks for your responses.

 

[GinaWhipp]

Does that mean it's working? If not, is there any other code behind the Form? If yes, please post...

 

[Tee2]

docmd.openform ("formname")
forms("formname").filter = "[ID] = " & sID
forms("formname").filteron = true

That works but I never figured out why it was ignoring the filter on my original line. Oh well!

 

[GinaWhipp]

That is odd but let's just be happy it's working...