Is it possible to select a record based on 2 fields in combo box? 1

[lwilly]

I would want to give users the ability to select a record in a table with a combo box. Sounds simple enough but the twist is that it takes two fields to make the record unique. Maybe my question should be, is it possible to bind a combo box to two fields?

 

[DougP]

Yes with VBA anything is possible

Dim SQL1 As String
SQL1 = "SQL1 = "Select * From yourTable Where Somefield = '" & Me!Combo1.Column(1) & "' AND Otherfield = '" & Me!Combo1.Column(2) & "';"
Me!Form.RecordSource = SQL1
DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive