Form handling

[Erik_norway]

Hi!

I really hope somone can help me with my problem. I have a table "company" that contains (naturally) data om various companies. However in one form i wish that the user can put in a nine digit number and if this number already exits in the database all is good. But if this number doesent exist in company table i want my company form to open and allow the user to complete the registration of this new company. The user is operating in a form based on another table "data". When registration is complete i want to return to the previous form and continue registration.

I`m very grateful for all sugestions..

Erik

 

[Roger Carlson]

On my website(see sig below) is a small sample database called
"NotInList.mdb", which uses the Not In List property of the combo box to do
this. There is another sample NotInListAlternative.mdb" which does it in a
different way. Perhaps they will give you some ideas.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

Hi!

I really hope somone can help me with my problem. I have a table "company"

that contains (naturally) data om various companies. However in one form i
wish that the user can put in a nine digit number and if this number already
exits in the database all is good. But if this number doesent exist in
company table i want my company form to open and allow the user to complete
the registration of this new company. The user is operating in a form based
on another table "data". When registration is complete i want to return to
the previous form and continue registration.

 

[Erik_norway]

Hi,

im ever so grateful - that did the thing yest great.. thank you sooooo much!

Erik