Form – Comb Box to open a form

[gsandy]

I have a combo box (cmbJobs) in a form (frmData) which links to another table (tblJobs) . If the data entered into the combo box in not in the table (tblJobs) I wish to open the form (frmJobs) associated with that table. I will then create a new record, close the form and carry on entering data in the original combo box (cmdJobs). How can this be done?

Thanks Sandy.

 

[GinaWhipp]

Perhaps the Not_In_List event of the Combo Box...
http://www.blueclaw-db.com/access_notinlist_advanced_example.htm

 

[gsandy]

Thanks for the link GinaWhip I will work through the code in the next couple of days and get it working in my case. Cheers Sandy

 

[GinaWhipp]

If you have problems, remember, we're here to help!