Browsing Recordsets with a ListBox

M

Mirco Wilhelm

I made a form showing all data of a table recordset. I want to select each
recordeset by clicking on a related itemlist (eg. names) in a ListBox.

Does anyone have an idea how to do this?
 
A

Arvin Meyer

Mirco Wilhelm said:
I made a form showing all data of a table recordset. I want to select each
recordeset by clicking on a related itemlist (eg. names) in a ListBox.

Does anyone have an idea how to do this?
Click to expand...

I am not sure what you mean by *each* recordset. There is only 1. I think
you mean the rows from within that recordset. Use the AfterUpdate event of
the List Box to open a form with the values from the recordset.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query a recordset? 3
set unbound listbox recordset to sorted and filtered ADO recordset 0
Requery listbox 1
You'll need a new app to open this about link 1
VBA-- Open a Form with filter accoding to LISTBOX multiple choices 3
Create recordset after load 4
Query delay 2
Query Delay 17

Top