Combo Box Search
in [Form]
|
Prev: How can I show multiple Pivotchart forms on the same screen at
Next: Formatting phone field based on value in another field
From: Mark on 15 Apr 2010 15:17 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.
From: Dirk Goldgar on 15 Apr 2010 15:32 "Mark" <Mark(a)discussions.microsoft.com> wrote in message news:FB0916D4-F3E8-4F91-8076-024027DD6FC9(a)microsoft.com... > 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 > 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)
From: Ash222 on 16 Apr 2010 11:24 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" <Mark(a)discussions.microsoft.com> wrote in message > news:FB0916D4-F3E8-4F91-8076-024027DD6FC9(a)microsoft.com... > > 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 > > 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) >
From: Dirk Goldgar on 16 Apr 2010 15:27
"Ash222" <Ash222(a)discussions.microsoft.com> wrote in message news:A9C36B68-F036-4CB0-944E-29C17E653689(a)microsoft.com... > 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) |