sphere_monk
Registered User.
- Local time
- Today, 16:49
- Joined
- Nov 18, 2002
- Messages
- 62
I have what I think is a relatively common situation and I think there is probably an easy, obvious solution that I can't come up with. Can someone please help me? Here's the situation....
I'm using a recordset.Find command to find a workorder number that has been chosen in a combo box. I'm having no problem selecting and finding existing workorders.
The problem starts when I enter a new workorder. After entering a new workorder, I have the combo box requery so that it shows the new workorder number, however, if I try to select the new workorder the program can't find it in the recordset. If I close the project and reopen it, it finds it easily.
I'm guessing that my recordset is just not updating, but I've tried various ways of getting it to update, but I can't without throwing it out of sync and causing more problems. Am I missing something simple or should I be avoiding the Find method and doing this another way?
I'd appreciate any help I can get!
I'm using a recordset.Find command to find a workorder number that has been chosen in a combo box. I'm having no problem selecting and finding existing workorders.
The problem starts when I enter a new workorder. After entering a new workorder, I have the combo box requery so that it shows the new workorder number, however, if I try to select the new workorder the program can't find it in the recordset. If I close the project and reopen it, it finds it easily.
I'm guessing that my recordset is just not updating, but I've tried various ways of getting it to update, but I can't without throwing it out of sync and causing more problems. Am I missing something simple or should I be avoiding the Find method and doing this another way?
I'd appreciate any help I can get!