Filter issues

[Daveisalwayshere]

Hi guys I have a button that opens a second form and filters that form based on a text box on the first form(which remains open). the problem is that it does not filter the second form unless the second form is already loaded for some reason.

for example if i click on the buton it opens the form Unfiltered then i go back to the previous form without closing the first form, click the button again and it is then filtered

i attached the screen shot of the macro for the button and there are no other events on the second form

 

[CJ_London]

I don't use macros so not familar with the presentation but I suspect you do not need the '=' signs at the beginning

 

[Daveisalwayshere]

This is the formula that the wizard makes when you create an open form button. this works on all my other forms except 2. so i dont know what the issue could be. but if you have an event procedure that will replace the macro it would be worth a try

 

[CJ_London]

the code you would use instead of a macro would be

DoCmd.OpenForm "ScaffoldLogQuoteF",,,"[ProjectNumID]=" & Me.ProjectNum

As you can see, very similar, but no = sign

 

[Daveisalwayshere]

Thanks for the help. The Event procedure works but it is has the same issue It still seems thought that the page doesnt filter unless the child form is open first. i think i might have to Re-make my forms and see if that changes anything

 

[Daveisalwayshere]

Ok after Erasing and re doing the forms it fixed itself. I must have somehow corrupted the forms. thanks for the quick response though