Combo box - adding entries

[Guest]

I’ve got the pieces, I just can’t figure how to put them together.

Form #1 – bound to Requests table. Contains combo who’s record source is a
query listing all records in table Attorneys. Combo Limit to List is yes.

Form #2 – unbound form for adding new Attorney to the table. When closed,
form runs sql to insert data into table. They will add one record at a time.

Here’s where I get stuck.

A. If they enter something not in the list I want to skip the error message
and display form #2. I can get my form to display but I don't know how to
disable the ‘not in list’ error message generated by Access.

B. After they fill out the form and close, I need to get the key (autonumber
field) from the Attorney table that was generated for the new record and pass
that back to Form #1. That way they don’t have to go back into the combo to
select the attorney they just entered.

I don’t need actual code – just give me a few tips and point me in the right
direction! Or, if I'm totally on the wrong track let me know!

And, as always, THANKS!!

Lauri

 

[Guest]

Look at this link on "How to use the Microsoft Access Not In List event of a
combo box ", to add records to the table without opening another form

http://www.databasedev.co.uk/not_in_list.html

 

[Guest]

Thanks!! That bit of code got me on the right track!

My problem was I was trying to open the form so they could add the rest of
the info for the new attorney before actually adding the attorney to the list
- and that's why I couldn't get away from the Access error message.

Works like a charm now!

Lauri