Input field - optional entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field governed by a Select Query (based on a 'Names" Table) which
provides a list of names from which to select.
I sometimes want to enter a name not in the list i.e., overide the Select
Query, and enter a name not in the Table.

Seems I want to have my cake and eat it too. Is this possible ?
 
I have a field governed by a Select Query (based on a 'Names" Table) which
provides a list of names from which to select.
I sometimes want to enter a name not in the list i.e., overide the Select
Query, and enter a name not in the Table.

Seems I want to have my cake and eat it too. Is this possible ?
Click to expand...

That depends on the field. If the field is a Text field containing the actual
name text, then yes; you can set the Combo Box's Limit to List property to No.

On the other hand if you are actually storing a numeric foreign key to the
names table, then you cannot.

John W. Vinson [MVP]
 
Thank you John, simple and effective.
--
Glynn


John W. Vinson said:
That depends on the field. If the field is a Text field containing the actual
name text, then yes; you can set the Combo Box's Limit to List property to No.

On the other hand if you are actually storing a numeric foreign key to the
names table, then you cannot.

John W. Vinson [MVP]
Click to expand...
 
Back
Top