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" <(E-Mail Removed)> wrote in message
news:FB0916D4-F3E8-4F91-8076-(E-Mail Removed)...
> 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


--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

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" wrote:

> "Mark" <(E-Mail Removed)> wrote in message
> news:FB0916D4-F3E8-4F91-8076-(E-Mail Removed)...
> > 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
>
>
> --
> Dirk Goldgar, MS Access MVP
> Access tips: www.datagnostics.com/tips.html
>
> (please reply to the newsgroup)
>

"Ash222" <(E-Mail Removed)> wrote in message
news:A9C36B68-F036-4CB0-944E-(E-Mail Removed)...
> 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?

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)