Creating a drop down box in a form

[lovelylauralin]

I am new at access..I am using Access 2003
I have a table with fields for Project #, client, description, etc..

I want a form with a drop down box that shows all of my project #'s when I click on it... I would like to then be able to click on the project number and have all of the information for that record appear..

I have managed to create the form with the drop down box, but when I click on the project number the record information does not change....

Any help would be so much appreciated!!!!

 

[damonc]

These directions are for A2000, but should work for A97.

In the Forms windows, choose to "Create Form in Design View"

In the properties window, under the Data tab, choose the appropriate table as your Record Source.

Using the Toobox, create a new unbound Combo Box, the wizard should pop up after you click on the form in the place you want to box. In the first screen of the wizard, choose the third option: "Find a record on my form based on the value I selected in my combo box". Choose the appropriate field from the next window. Continue until you finish the wizard.

Now you can simply add the rest of the fields you want by dragging them from the Field List box.

That should work ok. I hope you can follow this easily.

 

[lovelylauralin]

I am sorry.. I forgot to say that I am using Access 2003.. \

 

[damonc]

This method will still work. Give it a try.

 

[lovelylauralin]

YAY!!!! I am sooooo happy! THANK YOU THANK YOU THANK YOU!
LOL..

Ok.. it worked..