select record on subform and return with a value

[xhoz]

Hey

i have a form with a listbox on it and a subform
when i select something in my listbox on the form, the subform shows the filtered records....

But i filter on areacode(listbox)...and i have for example 30 records with customers(id, names, streetname, phonenumber, ...)
When i click on a record in my subform...How can i get by clicking on a button or, ... the value of the customer-(id,name, street,...) out of that selected record(with my mouse) ?

can someone give me some information, or vba-code or write it in a small database?

(sorry for my english but i'm dutch )

greetz Xhoz

 

[llkhoutx]

To select the column (hidden or displayed) value in a list box:

private sub AButton_Click
dim irow as integer
dim ctl as control
set ctl=me!listboxName
for irow = 0 to ctl.listcount-1
if ctl.selected(irow) = true then
'ctl.column(ij,irow) gives you column ij (0 to n) in the selected row
'do something with it
end if
next
end sub