Combo box - adding entries

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

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