Combo box

[Sudha]

Hi,
How do I use a combo box on a form(for a query). the combo box must have the values from a field called 'Project'. the form must then display the record selected in the combo box

 

[wiklendt]

depending on your access version, go to your form's design view and make sure you have the controls wizard enabled. click on the combo box, add it to your form and the wizard prompt will appear. select the third option in the list "find a record on my form based on the value i selected in my combo box".... then follow the other prompts.

access will automatically enter the VBA code.

 

[duluter]

Here's a Microsoft support article that will help:
http://support.microsoft.com/kb/287658

Try Method 3 in the article.


Duluter

 

[Sudha]

Thank you very much.