Find a Record

[Guest]

Hi, I have this problem.... I have 6 fields , i want to create a combo box to
lookup all 6 fields but it only finds the first one. Can this be done ?

Thanks.

 

[Francis]

Yes of course
in RowSource: (introduce this query) SELECT field1, field2,field3,
field4, field5, field6 FROM tablewithfields
in columnWidth: 2cm;2cm;2cm;2cm;2cm;2cm

Hope it helped.

Havefun.
Francisco (portugal)

 

[Arvin Meyer [MVP]]

Set the combo's rowsource to something like:

Select Field1, Field2, Field ... From MyTable;

If you need to display the other columns, add text boxes that refer to them:

Me.txtField1 = Me.Combo.Column(0)
Me.txtField2 = Me.Combo.Column(1)
Me.txtField3 = Me.Combo.Column(2)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access