Appending a row to List box row source

J

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.
 
D

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.
 
Top