list box and moving selected fields to another list box

[pietjan]

I like to select records from a list box and move these selected records to another list box. Further, I want to save these selected records in a new table.
Finally, it would also be convenient to search in the first list box with a wildcard.

Could anyone help me with these questions?

 

[raymondo]

Don't know whether you've found the answers you need but in case not:
Create a command button and use its OnClick event to do what you want. But first some questions:
Is it really entire records that you want to move from one list box to another?
What is the source for the second listbox?
When saving the selected records, is it always a new table that is created?

 

[AtomicWedgie]

What I would do is something like this:

save the selected records in the new table and use this new table as the recordsource for your second listbox. After you have entered the records in the new table you have to refresh the second listbox so it shows the newly added values.

 

[pietjan]

raymondo,

Thanks for you answer. I'm rather new to MS-access, so how do you program what you suggested; if I use a text box in which I enter my "search criterion" how can I use this in order to run a query to fill my first list box?

Piet-Jan


AtomicWedgie,

Thanks for your answer. How can you save the selected records in another table?

Piet-Jan

 

[raymondo]

Piet-Jan,
Before launching off into code, when you say you're rather new to Access what does this mean in terms of VB?
I'm happy to help but exactly how much detail do you need?
Drop me an email and we'll take it from there. Hope this helps,
Raymondo
raymondo@rossar.net