Query for combo box

  • Thread starter Thread starter lavanya
  • Start date Start date
L

lavanya

I use ACCESS 2000.
I have query in my VBA code that will return more than
one row and I want it these values to be displayed in a
form - combo box for the user to choose one of the
records.
Does anybody have suggestions as to how I can do this ?
any help will be appreciated.
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

See the Access Help article:

"List Boxes, Combo Boxes and Drop-Down List Boxes
Customize a list box, combo box, or drop-down list box."

Hint: Change the ComboBox's RowSourceType to Table/Query. Put the
table/query name/SQL string in the ComboBox's RowSource property.

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

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

iQA/AwUBQDkVp4echKqOuFEgEQKfiwCdHgQdGV9evVj7N2mF+JsPKqfNWecAn3DG
Ic9mcZesFzebU0IBXJd5BK0r
=Yqia
-----END PGP SIGNATURE-----
 
Back
Top