Hello !
Teach me please how to deal with the NotInList event for a combo.
The scenario is very simple:
Two tables:
One of this table (T1) contain a field (FK2) that is a look up to the second table (T2).
The field FK2 is required field in T1.
Both tables contain, of course, more other required fields (I refer especially to T1).
Two forms:
Form F1 based on T1 and form F2 based on T2.
In F1 will be a combo cmbFK2 in order to add/edit the FK2 field.
Now, the problem:
I need an entry Enew that is not in combo list (because not exist in T2)
So, the NotInList event will raise.
On the other hand, Access will not allow me (at this time) to leave F1 (in order to open F2) because the required fields (in F1) are not filled (yet) with data.
The question is obviously:
How to manage this situation ??
Thank you !
Teach me please how to deal with the NotInList event for a combo.
The scenario is very simple:
Two tables:
One of this table (T1) contain a field (FK2) that is a look up to the second table (T2).
The field FK2 is required field in T1.
Both tables contain, of course, more other required fields (I refer especially to T1).
Two forms:
Form F1 based on T1 and form F2 based on T2.
In F1 will be a combo cmbFK2 in order to add/edit the FK2 field.
Now, the problem:
I need an entry Enew that is not in combo list (because not exist in T2)
So, the NotInList event will raise.
On the other hand, Access will not allow me (at this time) to leave F1 (in order to open F2) because the required fields (in F1) are not filled (yet) with data.
The question is obviously:
How to manage this situation ??
Thank you !