Appending a row to List box row source

[JimP]

I would like to append a row to a list box row source that uses a query as
it's source. I can think of a way to do this using a union query - but would
like to know if there are other options.

 

[Douglas J. Steele]

If the RowSource is a query, then your only option is to add the record to
the source of the query, either by adding it to the underlying table, or
creating a UNION query that joins the new data to the existing data.