Not on list works on tables but not on sub-form.

[TenOc]

I do not know if this should be in Forms or programming or Tables. I have a table with a field that is a lookup combo box with "limit to list" YES and "allow value list edit" NO. When I attempt to input an item not on the list directly into the table I get an expected error not on list. Thus it is working as it should.

However, if I enter data from a sub-form into a new record and enter an item (or edit the field) to an item not on the list the program accepts the not on list input and post it to the table with out any errors.

I have tried to trigger on the sub-form an "not in list" event for a message box and again without any success. I think (?) I read someplace that a sub-form is closed AFTER the main form so the event not in list on the sub-form may not happen, but the Table rules should have found the error.

[TenOc]

I found the problem. There is a "not on list" property also on the sub-form. I set it and all works now.

[June7]

I am glad you resolved issue but description of issue and resolution are confusing.

NotInList is an event of combobox, not a property of form.

[Minty]

Lookup fields should be avoided in table design.
Have a read here for some background. http://access.mvps.org/access/lookupfields.htm

[TenOc]

I am glad you resolved issue but description of issue and resolution are confusing.

NotInList is an event of combobox, not a property of form.

I should have said "Limit to List" on the sub-form's combo box.