Requery Combobox lookup on table datasheet

[phuile]

When designing a table I've created a field and set its lookup
properties to display a combobox with a row source that returns a
DISTINCT set of values already entered into the field.

After a row insert or row update the combobox needs to be requeried
to ensure its list is complete.

If I create a form to display my datasheet this is easy. But I'd
prefer to enter data directly into the table datasheet directly. I
need to enter simple data into about 20 different tables and I'd
prefer not to create 20 forms unless it's really necessary.

The lookup wizard generated entries similar to those I'd previously
created manually, except the wizard generated a couple of extra
settings that appeared briefly that were not part of the regular set
of lookup tab properties. These additional settings referred to
'update propagation'. Once they'd disappeared I couldn't see any way
to get them back.

Thank you to anyone who can enlighten me.

(I am using Access 2013)

 

[EternalMyrtle]

If I create a form to display my datasheet this is easy. But I'd
prefer to enter data directly into the table datasheet directly. I
need to enter simple data into about 20 different tables and I'd
prefer not to create 20 forms unless it's really necessary.

You should create a simple form and be done with it.

 

[EternalMyrtle]

20 forms sounds like a lot but can some be combined with subforms? Are these 20 distinct tables with no relationships (if so, why? that shouldn't be)? I am sure there is some way to design this properly and not end up with dozens of forms.

 

[EternalMyrtle]

Also, unless the lookups are in value lists (and are not FKs to other tables), you should remove them from your tables and change the data type to number.