Having form trouble

  • Thread starter Thread starter Chrissy
  • Start date Start date
C

Chrissy

I have a customer table and a form for entering
information into this table. I also have a Files Received
table with a form for entry into this also. In this Files
Received table I have CustomerName as Required so that I
don't have files received without a customer name. What I
want to do is when the user is entering the customer name
in the FilesReceived table, and there is no customer in
the customer table that matches, I want them to have an
option to add this customer, automatically open the
Customer form and automatically enter the name they tried
to enter into the CustomerName field, they can then enter
appropriate info, close the Customer form and be able to
use this newly entered customer in the FilesReceived
form. Is there a way to do this?

Right now the only way I can get it to sorta work is
having the CustomerName as not required, the user after
entering the incorrect name has to backspace out of it,
then click the ADD button to go to the customer form.
When closing that form they have to go to Reports-Refresh
to be able to use the customer they just entered. This is
just a bit too complicated for me to ask them to do. Any
help would be greatly appreciated!!!!
 
Chrissy,

The best way to handle this is to not use a regular text box
to Enter the Customer's Name (ID would be preferable), but
rather to use a ComboBox that looks up the Customers from
the Customer table.

A couple of advantages here. When the user starts to type a
name, it will autofill the rest of the name if it is in the
table. The ComboBox also has a LimitToList setting that will
prevent misspelled names and also trigger a NotInList event
that can be used to question the user about adding and then
you can open the Customer form from this event and then
requery the original form with the OnClose event of the
Customer form.

Look in Help for NotInList.


Gary Miller
Sisters, OR
 
Back
Top