David R
I know a few things...
- Local time
- Yesterday, 18:54
- Joined
- Oct 23, 2001
- Messages
- 2,633
This is a really weird one (I think I say that every time I make a thread anymore, just goes to show how much I've learned here...)
I have a form/subform that requires some fields from the Switchboard for its criteria. Last week due to no action on my part, it started asking for those values as Parameters instead (Forms!Data!txtInspDate), etc! The new form loads, but of course it is blank with no data. This happens if I load it from a command button or from the navigation sidebar... UNLESS I first load the switchboard in Design Mode, go to VBA window, then reload the Switchboard in Form Mode and press the button. From then on until I close the database, everything works fine!
I've tried compacting and repairing. I think I've looked at all of my references in the new form and the query it is based on... I've had this happen once or twice before over the years but can't remember the solution, and search is failing me due to the general nature of the problem.
Any ideas?
I have a form/subform that requires some fields from the Switchboard for its criteria. Last week due to no action on my part, it started asking for those values as Parameters instead (Forms!Data!txtInspDate), etc! The new form loads, but of course it is blank with no data. This happens if I load it from a command button or from the navigation sidebar... UNLESS I first load the switchboard in Design Mode, go to VBA window, then reload the Switchboard in Form Mode and press the button. From then on until I close the database, everything works fine!
I've tried compacting and repairing. I think I've looked at all of my references in the new form and the query it is based on... I've had this happen once or twice before over the years but can't remember the solution, and search is failing me due to the general nature of the problem.
Any ideas?