Rowsource not updating

Rated 3.86/5 based on 816 customer reviews

The auto-expand makes it quick to enter similar comments, but it gives no accuracy.

It is unnormalized, and completely unsuitable if you might need to count or group by the lookup category.

But lets ignore this wisdom, and explore what happens of you store the value list in the table.

Select the field in table design, and in the lower pane (on the Lookup tab), set the properties like this: Now create a form using this table, with a combo for this field.

The list automatically shows the current items next time you open the form.

This approach is useful in only very limited scenarios.

It is not written to the real table in the back end.

Just set this property to the name of the form that should be used to manage the items in the combo's list.

Use this event to add the new item to the Row Source table.

When you enter something that is not in the combo's list, its Not In List event fires.

Set the combo's Inherit Value List property to Yes.

Now Access ignores the Row Source list in the form, and uses the list from the table instead.

Leave a Reply

  1. updating a page 11-Sep-2017 14:08

    Oggi aggiornavo la mia agenda, fittissima di appuntamenti (ne sono strafelice!

  2. serious end dating how to 14-Nov-2017 19:10

    The late Ritter was especially funny — a drama student at the time, he mugged for the camera in a very Jack Tripper way.