access queries

  • Thread starter Thread starter aannan
  • Start date Start date
A

aannan

I have a search form with a number of parameters eg. last name, id
number, age(selected from a combo box). On the same form, I have a
list box in which i want the results to be displayed once i choose my
parameters and hit a search button. Also when the results have been
displayed in the list box, i want to click on a record and open the
record in a form. How do i go about this. would very much appreciate
your help. Thanks
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

In the CommandButton's OnClick event you'll have to use VBA to create
the SQL string; put the string in the RowSource property of the ListBox.
Then use the ListBox's Click or Double-Click event to get the selected
item's identifying value to open the form (use the OpenForm's
WhereCondition parameter).

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQVRtl4echKqOuFEgEQINxwCeIjometNneKjdTMHPIchS4pmpQMUAoIuz
SzNgTNwg5qOeD7lPRl2wOuN/
=3zIb
-----END PGP SIGNATURE-----
 
Back
Top