Richard,

My database is for an ambulance service.  When I enter in a run into that table one of the pieces of information is the patient that comes from the patient table.  I use a combo box to select the patient from.  I would like to use the on not in list event to add a new patient record if it does not already exist.  I was thinking that I could just use a recordset and several input boxes as you suggest to get this patient added but being able to have the patient form pop up would be much neater.  I guess I would like to add my name to those that want to see how you would do that.

---

Reply from Richard Rost:

OK. In the mean time, a temporary solution is:

1. If the patient isn't in the list, make a button to open your patient form
2. When the patient form closes, issue a Forms!RunForm!ComboBox.REQUERY

That should give you a quick way to add a patient without needing On Not In List. You just need to put an "add patient" button next to the box.