Combo Box Search

[Mark]

Hi

I am fairly new to access and have just created a large database for work.
The only way I have found to search the records is through a combo box. I am
trying to browse people by surname. I have four people by the last name barry
now if i select the 3rd record in the list it takes me to the first record
everytime. Is there anyway to change this?

Also I would like the drop down box to appear when you type like in facebook
and not once I have clicked the arrow is this possible.

 

[Dirk Goldgar]

Hi

I am fairly new to access and have just created a large database for work.
The only way I have found to search the records is through a combo box. I
am
trying to browse people by surname. I have four people by the last name
barry
now if i select the 3rd record in the list it takes me to the first record
everytime. Is there anyway to change this?

The combo box can't distinguish records that are identical in the displayed
column. So you need to make that column not have any identical values. Set
the combo box's RowSource to a query that creates a calculated field
including last name, first name, and (if desired) middle initial. For
example,

SELECT ID, LastName & (", "+FirstName) As FullName
FROM Contacts
ORDER BY LastName, FirstName

Also I would like the drop down box to appear when you type like in
facebook
and not once I have clicked the arrow is this possible.

I'm not sure what you mean, not being a FaceBook user, but you can make the
combo box drop down when it gets the focus, using code for its GotFocus
event. For example,

Private Sub cboYourComboName_GotFocus()

Me.cboYourComboName.DropDown

End Sub

 

[Ash222]

Hi Dirk - I have a similar situation that I was wondering if you could help
me on. I have a database of suppliers and I need a search capability on the
form that shows only the suppliers that meet a search criteria. Ex. shows
only suppliers with "Active" status. Any ideas? I've tried to put a combo
list box in the form, but as you said below it does not eliminate the
duplicates.

Thanks!

 

[Dirk Goldgar]

Hi Dirk - I have a similar situation that I was wondering if you could
help
me on. I have a database of suppliers and I need a search capability on
the
form that shows only the suppliers that meet a search criteria. Ex. shows
only suppliers with "Active" status. Any ideas? I've tried to put a combo
list box in the form, but as you said below it does not eliminate the
duplicates.

I'm not sure what you have in mind. Are you wanting to build a combo box
that always lists only active suppliers? Or do you want to control what the
combo box shows -- active, inactive, or all suppliers -- according to some
other control? Or, a third possibility, do you want to list all suppliers,
but have the list entries be marked as to whether the supplier is active or
inactive?