spanner
09-19-2001, 12:28 AM
Im a real beginner when it come to access! Here what I wanna do! I have a table that contains a list of surnames, fornames, usernames and then passwords! I have designed a form that I want to use...it has a label, next to a text box, and then a button next to that! I have this repeated 4 times! one for each field! what I want to do - is to be able to enter any one of these fields hit the button next to it...and then this will search the relevant table! I havent a clue! somebody please help! Many Thanks
Pat Hartman
09-19-2001, 04:24 PM
The easiest thing to do is to get rid of the buttons and unbound fields that you have now. Create a form that shows all the information you want. Then add four combo boxes to the top of the form. One for each of the fields that you want to search on. The wizard will walk you through the process. One of the options is to use the value in the combo to find a record. That is the one to choose.
spanner
09-24-2001, 12:35 AM
umm...thank you! im still lost - dont know how to do the combo boxes - the wizard doesnt seem to be helping me! How do i make a list be seen in the combo box?
lscheer
09-24-2001, 03:41 PM
What wizard are you using, the form wizard or the combo box wizard?
lscheer
09-25-2001, 08:16 AM
The form wizard (to my knowledge) won't help you with combo boxes. You can either finish the form using the wizard, then go to the design view and right-click on the field you want to be made a combo box. Select change to, and then combo box. You can adjust the properties for the combo box from there (there's much to read in the Help files on how to get what you want in a combo box).
Or, you can finish your form, then delete the field you want as a combo box and re-add it using the combo box wizard. Basically, in design view, make sure the magic wand on the toolbox (typically floating) is selected, then select the combo box tool. The combo box wizard will start. At the end of the wizard you have the option to view additional help files on how to customize your combo box. I suggest clicking on this before finishing the wizard. Let me know where you get and we can continue to try to help you.