Query Randomly Broke (1 Viewer)

[Kheribus]

Hello,

I was working on some code in a form and i switch from layout mode to form mode and all of the sudden a query that's referenced by my subform isn't working. I didn't change anything releveant that should have triggered this break.

I have two nav menus so the reference to the combo data that drives the form is the query criteria <= [Forms]![Navigation Main Menu]![Navigationsubform].[Form]![Navigationsubform]!.[Form]![startDate].

I really changed nothing that should have broke my query.

Can anyone think of a reason why a query would stop working if you haven't changed the names of any of the query criteria referenced feilds?

 

[arnelgp]

that is the flaw with Navigation form, all got invalidated until you actually go to each navigation subform.

 

[Kheribus]

So how do i fix this? By clicking on each navigation subform link? I've tried that and the parameter dialogues won't go away ie my query isn't working.

 

[Kheribus]

Nevermind. That may have worked.

Also, I noticed that I had two _afterupdate() routines for the same field. I don't know if this caused it to bug out or not.

Thanks