Help needed with form and Combo box

[Guest]

This is probably very simple and I have overcomplicated things
I have a form which uses a combo box to pull data from my client database
where once found there details appear on the form which is actually a new
quote/job

ClientID / Name / Address
JobID / ClientID / Job data

ClientID being related. On the form for Jobs I use a combo box to pull in
the details of the customer uses ClientID

The problem is that I may start a new job unaware that the client does not
exist, then obviously it puts up an error message. I would like the ability
to enter a new client using the same form, therefore:

If I enter a new client it gives a blank job with no client data
I then enter both client and job data at the same time uses the open form
It then autoupdates the client table and adds the new job in the job table

Any help gratefully received?

 

[kingston via AccessMonster.com]

Set the combobox's Limit To List property to Yes and create a procedure for
its On Not in List event. This procedure would insert the new client data
into the client table and refresh your combobox. How have you set up the
form(s)? Are you using a subform or do you have multiple forms?