If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help with Access FORM
I've created a form for a listing of approximately 250
names, addresses, etc. This form will be placed on other computer desktops (as Access data pages) for staff to utilize the data. At the top of the form I would like to have a search, so that staff will only have to type in the name of the person they are searching for, in order to bring up that form, an not have to cursor through the whole listing. I've created a drop down box, that shows the whole list of names, in alphabetical order, but cannot highlight a specific name to bring the form up....thoughts, suggestions, HELP?! Thank you. |
#2
|
|||
|
|||
Help with Access FORM
Kim,
Your drop down box should be unbound and the row source should be PersonID, LastName & ", " & Firstname. The bound column should be 1, column count 2 and column width 0;2. Go to the Data tab of properties and set Autoexpand to Yes. Name the comobox "MyCombobox". Put the following code in the AfterUpdate event of the combobox: Dim Rst As DAO.Recordset Set Rst = Me.RecordsetClone Rst.FindFirst "[PersonID] = " & Me!MyCombobox Me.Bookmark = Rst.Bookmark Rst.Close When you begin typing in a last name, the dropdown list will automatically scrool to the first last name beginning with the letters you typed in. When you select a name in the dropdown list, the form will automatically jump to that record. -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "Kim" wrote in message ... I've created a form for a listing of approximately 250 names, addresses, etc. This form will be placed on other computer desktops (as Access data pages) for staff to utilize the data. At the top of the form I would like to have a search, so that staff will only have to type in the name of the person they are searching for, in order to bring up that form, an not have to cursor through the whole listing. I've created a drop down box, that shows the whole list of names, in alphabetical order, but cannot highlight a specific name to bring the form up....thoughts, suggestions, HELP?! Thank you. |
#3
|
|||
|
|||
Help with Access FORM
Why not teach the users to use the "find" tool with the
surname field on the Form......it's the Binocular Icon or you can get it in Edit/Find Jim -----Original Message----- I've created a form for a listing of approximately 250 names, addresses, etc. This form will be placed on other computer desktops (as Access data pages) for staff to utilize the data. At the top of the form I would like to have a search, so that staff will only have to type in the name of the person they are searching for, in order to bring up that form, an not have to cursor through the whole listing. I've created a drop down box, that shows the whole list of names, in alphabetical order, but cannot highlight a specific name to bring the form up....thoughts, suggestions, HELP?! Thank you. . |
Thread Tools | |
Display Modes | |
|
|