Form handling

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

Guest

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
 
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

Erik_norway said:
Hi!

I really hope somone can help me with my problem. I have a table "company"
Click to expand...
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.
 
Back
Top