How to create pop-up with new form in response to...

[PraystoYeezus]

Hello all,



My database features employees and teams - of which there are many. The problem is that right now if I am in a form creating a record for a new employee who will start in a new team/group, when I type that team into the relevant combo box Access (rightly) displays an error that the team does not exist.

What I'd like to do is, instead of showing this error, have a message pop up saying that the team must be created with the team-entry form (which I already created) showing below. I feel like this should be possible but I am feeling very frustrated at the moment.

[Dal Jeanis]

set the combo box with Limit to List = Yes.
Use the NotInList event to display the team entry form as a subform.
When the team entry is complete, save the new team, requery the combobox, and set its value to the newly added team value.

[PraystoYeezus]

Thank you. I'll try that tomorrow when I get back to my work site and let you know how it goes. Will the sub-form show up as a pop-up, too, or just the ''error'' message?

[Dal Jeanis]

If I've pictured it correctly, there shouldn't be an error message.

If you still get an error message, then you may have to (1) unbind the combo box from the Team ID field in the table (2) create a text box bound to the Team ID field in the table (Enabled = No) (3) In the AfterUpdate of the combobox, if the team ID is good, set the value of the textbox to the selected value, otherwise pop up the form for entering the new team, and after the new one is added, refresh the list in the combobox.

This would fix the timing issue.