Accumulating Listbox 1

[andzejek]

How to create a listbox to which I will add records. Let say I have a three commandbuttons which will create three recordset with onclick event. How to create a listbox which will add records after each clicking?

Andrew

 

[orna]

Me!ListBoxName.Requery

 

[andzejek]

Yes, bu you see, I have one recordset which I'm showing in the listbox and I want ad some records from another recordset.

 

[orna]

Change the row source of the listbox to a query that retrieves the new record too.

 

[andzejek]

Here is the problem, how to change this query so it will be retrives both old and new records

 

[orna]

What is the listbox rowsource now?

 

[SeeThru]

Union queries are your friend!

Select [Whatever] from Table1
Union Select [Whatever] from Table2


Requery the list box each time there is a change.

 

[andzejek]

Thanks!