Is this possible...

[davper]

I have a form based on table1 where the user must select an EFFORT TYPE that is based off of values in table2 with limit to list enabled.

I want to include in the combobox a value labeled ADD NEW EFFORT TYPE. when the user selects this item, another form (based on table2) pops up allowing the user to enter in a new effort type with all the associated data. When complete, the user closes the form and the newly created value is passed to the original form.

I have tried beforeUpdate and afterchange events. Each time I either get an error before the popup telling me a related record does not exist or that value does not get passed back to the original form.

Here is the query to create the list

select Distinct  " ...Add New Effort Type" as Name, 0 as ClinEffID FROM qry_Clinical_Effort_Types
union all
SELECT qry_Clinical_Effort_Types.Name,qry_Clinical_Effort_Types.ClinEffID FROM qry_Clinical_Effort_Types ORDER BY [Name]

Please and Thank You

 

[SpentGeezer]

Try this sample

 

[davper]

Try this sample

Wow! You actually went through the trouble of creating an example. I am so appreciative.

Your example is spot on. I'll dig through the code and adapt to my app.

Thank You So Much!