Using a list box selection

[bailey]

Right, I have the 1 database and a nice front-end form
with different options (the usual). 1 Particular option
has a list box which displays values from a field that
comes from a back end table.

What i would like to do, is to be able to make a
selection from the list and hit a 'GO' command button
which will then display that selected record in a form I
have created. (Sort of like a 'findrecord' action)

LAYOUT:
TABLE1 (All data comes from here)
FORM1 (main form display of records)
FORM2 (with list box)

At the mo, when hitting the go button it will always
display the first record rather than the record I
selected from the list box. I cant find the right action
for my macro.
I hope this makes a bit of sense!!!
Could anyone help with this probably simple process???

Much appreciated.

 

[Roger Carlson]

On my website is a small sample database called "ComboChoosesRecord.mdb".
Now this sample uses combo boxes to do the choosing, but the same method
works for listboxes.

--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org