Drop down

[BigAl.NZ]

Hi Guys,

I have made a drop down box that lists both first name and last name,
but when you actually select a name it only shows the last name - how
do you make it show both?

Also how do you make the combo box update depending on the current
order?

Thanks

-Al

 

[Guest]

You have two choices I think:
1. Have to text boxes on your form that the dropdown is sitting on as
txtFirstName and txtLastName. Bound these text fields to FirstName and
LastName fields from the query or table that your form is based on.

2. Have a text box on your form, for instance, txtName and put the
experssion such as =[FirstName]&" "&[LastName] as its data.

Hope that helps.
Don't know about about your last question on updating combo box. Make it
clearer.