Combobox New Record Row

[guysandford]

Hope you can help with my problem...
I have a continuous subform containing a bound combobox
What I want to achieve is for the new record row combobox to display
text such as "Add another..."
Normally I'd achieve this by setting rowsource to SELECT...UNION SELECT
Null,... etc etc
In this case however, the required property needs to be TRUE, and the
NotInList event needs to be triggered (to add NewData to bound table)

ANyone help?

 

[Guest]

If you put something like "Add Another" in you row source (which is not hard
to do) and you select it, the Not In List event will not fire (because it is
in the list).

Th usual way to do this is to allow the user to enter a value. If it is not
in the list, present a message box in the Not In List event to warn the user
and allow them to either create the new record or cancel.

 

[kingston via AccessMonster.com]

If you add a selection called "Add another..." then it will be in the list
and NotInList will not be triggered. Could you not add a fake record to the
underlying table with the intent of using the record as a trigger? It would
have the same effect except you have to "reserve" it in all other
transactions.

 

[guysandford]

Sorry, but perhaps I wasn't very clear.

All I want to achieve is for the combo box to show some text such as
"Add another..." without adding it to the row source (as this will
prevent the triggering of NotInList).