Christian,
The listbox only reads it's RowSource when it constructs. If you change the RowSource then you need to call the ListBox.Requery() method to get it to repopulate itself.
>I have trouble with a listbox that is on a data entry form:
>The listbox shows the list of records of a table, the controlsource is set to this table and the rowsourcetype is FIELDS etc.
>
>If I append a record in the table, the listbox does not show a new empty record, but stays on the last record. Because it has as controlsource the table, it forces the table back to the last record, unless I first clear the controlsource property and then do the append.
>
>So the result is a total mess altogether.
>What do I wrong here?