kelsita_05
Registered User.
- Local time
- Today, 12:55
- Joined
- Aug 23, 2005
- Messages
- 52
I am using an OpenForm Macro that filters on a parameter query to open a record in the user-friendly form view. The query prompts the user for the "job no." and then displays the correct record. It has worked fine, but lately it is failing to open records that I know exist.
The macro has to be working because it still brings up the form, it's just empty. That is the typical behavior when no record is found. However, I found the record in the table, so I know it exists. I assumed it was user error, but even when I copy and paste the "job no." from the table into the parameter box, it doesn't show up. This has happened with multiple records.
Is my query tired? Dying? It's never done this to me before and I'm feeling a little betrayed.
Any ideas what might be causing it?
Thanks so much!
The macro has to be working because it still brings up the form, it's just empty. That is the typical behavior when no record is found. However, I found the record in the table, so I know it exists. I assumed it was user error, but even when I copy and paste the "job no." from the table into the parameter box, it doesn't show up. This has happened with multiple records.
Is my query tired? Dying? It's never done this to me before and I'm feeling a little betrayed.
Any ideas what might be causing it?
Thanks so much!
