Combo Box Search

  • Thread starter Thread starter Mark
  • Start date Start date
M

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.
 
Mark said:
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?
Click to expand...

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.
Click to expand...

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
 
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!
 
Ash222 said:
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.
Click to expand...


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?
 
Back
Top