If Record Does not exist then..

[Chief]

Hello,
Using Access 2010.

I have a form (frmClientContact) with a field Company Name. It is a combo box the data of which comes from another table.
What I require - If the Company does not exist and I type the new company name in the box, I want another form (frmClients) to open so the new client company details can be filled out. The New company name should already be filled in at required field and the cursor at next fielf ready for data entry.
Then once completed go back to the client contact form and complete the contact details.
Not sure if this is all macro or I should write the code or what code to write. Im thinking code then I can use it thru out the database where requried?
Appreciate the help, Thanks.
Jason

 

[John Big Booty]

The sample here demonstrates a method you can use to add items to a Combo Box list, and also push that newly added value back to the Combo as the value in the current record.