Auto fill in

[Alan]

I have a table named Agency. In this table are the Agency Name, Contact
Name, Contact Phone, Contact Cell, Contact Fax, Contact E-mail, Agency
Address, Agency City, Agency Phone, Agency State, Agency zip, Agency County,
Agency Fax, Agency ID.

I also have a Agency Sub form, that allows users to enter this information.

What I would like to do is have the informtion automtcially fill in, if it
already exists. Much like Outlook when you type in the name of a person in
the To: field, it will bring up the names of people or contacts that have
that letter.

I would to have the user select the agency they want (may be from a list)
and have it fill in all of the above mentioned fields.

If a new Agency is entered that is not on the list, I would like it to be
added.

Any ideas? Or am I dreaming?

Thank you,

Alan

 

[Guest]

Hi Alan,

Check out the Orders form of the sample Northwind.mdb database, which may
already be installed on your hard drive. When you select a product, the
unitprice, quantity (defaults to 1) and discount are entered automatically.

If a new Agency is entered that is not on the list, I would like it to be

added.

Check out Allen Browne's sample:

NotInList: Adding values to lookup tables
http://allenbrowne.com/ser-27.html


Tom
________________________________________

:

I have a table named Agency. In this table are the Agency Name, Contact
Name, Contact Phone, Contact Cell, Contact Fax, Contact E-mail, Agency
Address, Agency City, Agency Phone, Agency State, Agency zip, Agency County,
Agency Fax, Agency ID.

I also have a Agency Sub form, that allows users to enter this information.

What I would like to do is have the informtion automtcially fill in, if it
already exists. Much like Outlook when you type in the name of a person in
the To: field, it will bring up the names of people or contacts that have
that letter.

I would to have the user select the agency they want (may be from a list)
and have it fill in all of the above mentioned fields.

If a new Agency is entered that is not on the list, I would like it to be
added.

Any ideas? Or am I dreaming?

Thank you,

Alan