combo box search

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a combo box that is based on a query.
PrimaryKeyID, Lastname, Firstname.

I want the user to be able to search on the lastname but
i need the PrimaryKeyID stored.

thanks for the help.

patti
 
Set the Bound column property of the combobox to 1. This makes the
PrimaryKeyId the value that will be stored in the table. In the ColumnWidths
property, put:
0"; 1"; 1"

This make the PrimaryKeyId hidden and allows the users to enter/search by
LastName.

Barry
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo box to display something else if field is blank 1
Combo box - Show 3rd Column in resulting selection 2
How to control what is displayed in a combo box 4
Add/Edit Records Via Combo Box 7
Change value based on combobox not working 1
Update Table based on Multiple List Box selections. 3
Combo box that will select and Go To a record on a form? 1
autoexpand or add concatenated name 2

Back
Top