Steve@trop
Registered User.
- Local time
- Today, 10:24
- Joined
- May 10, 2013
- Messages
- 148
Users enter customer information into a form I created. The underlying table has an index set up to prevent users from entering duplicate customers. The index is made of two table fields (last name and phone number). I've got error handling set up so that if they enter a duplicate customer it instructs them to do a search to open the form on the existing customer. They don't like the extra step of doing the search. They want me to set it up so that instead of asking them to search for the existing customer, the form simply opens to that customer so they can edit it or add orders to it. I've tried various ways of doing this but haven't had any luck getting them to work correctly.
I've tried having the form close and then re-open to the correct customer but for some reason the form always comes up blank when it opens instead of opening to the record I want.
There is probably a simpler way. Anybody got ideas?
Thanks,
Steve
I've tried having the form close and then re-open to the correct customer but for some reason the form always comes up blank when it opens instead of opening to the record I want.
There is probably a simpler way. Anybody got ideas?
Thanks,
Steve