multiple fields in my combo box

  • Thread starter Thread starter Dave Smith
  • Start date Start date
D

Dave Smith

hi, i have a combo box which is used to select my clients. at the moment i
type in my surname & if needed, click on the arrow & select etc. when i
click on the arrow i can see my surname, first name & address (as expected),
what i'm wanting is, when i type my surname, that it "autofill" not just the
surname but the first "firstname" & "address"as well. then if thats not the
one, to continue typing, put a comma, start typing the "firstname" that i
want & so on.

Thank you in advance

Dave Smith
 
Thanks For that it WORKS!!!

Dave Smith

Arvin Meyer said:
Use a concatenation of those fields as the RowSource of the combo box,
something like:

Select ID, [LastName] & ", " & [FirstName] & " " & [Address] As Expr1 From
MyTable;
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Dave Smith said:
hi, i have a combo box which is used to select my clients. at the moment i
type in my surname & if needed, click on the arrow & select etc. when i
click on the arrow i can see my surname, first name & address (as expected),
what i'm wanting is, when i type my surname, that it "autofill" not just the
surname but the first "firstname" & "address"as well. then if thats not the
one, to continue typing, put a comma, start typing the "firstname" that i
want & so on.

Thank you in advance

Dave Smith
Click to expand...
Click to expand...
 
Back
Top