Not in List error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an order system. The user first chooses the appropriate vendor to
create an order. I have a combo box where the user can choose the vendor by
selecting it or by starting to type it. If they type a vendor name and it
isn't in the database yet, it prompts them and asks if they want to add it as
a new vendor and it takes them to a form where they fill out all the
information for a new vendor. As soon as they save and close that form, it
goes back to the original form where they choose the vendor but it prompts
them to add it again because the value they typed is still in that combo box.
Is there a way to clear out that field so they are starting fresh and can
begin typing the name of the vendor they just added? Please help!

Thansk!
 
I think the other form (where they enter the address and other information)
needs to do a requery on the combo box before terminating.

To then save the user from having to re-enter the name of what was just
typed in, that second form could also (after the requery and prior to
terminating) set the value of the combo box to the value of the item just
entered. If the combo box has a zero-width column containing the vendor's
key, simply have the second form move that value to the combo box and then
issue a setfocus to wherever on the first form you want the user to be
pointing to next.

Then when the second form terminates, the first form should be properly
prepared. The query behind the combo box should be current, the entire
vendor's name should be in the combo box, and the focus should be in the
proper control for the user's next step.

Bob (@Martureo.Org)
 
Thanks for your answer. Where exactly do I put the requery line? Where in
the form module?

Thanks!
 
Back
Top