Combo Box Security

[jayk]

Hi

I have a combo box, which allows me to select a company name. When I choose the company I want, other details, such as Address and telephone number are displayed in seperate fields underneath.

I can currently type within the combo box and edit it fully but all I want to do is select the drop down arrow and choose the company I want in order for the specific details to be displayed - NO EDITING.
I dont want a cursor to exist within the combo box or anything other than a company name be selected within it! Can anyone help....preferably using a tool rather than a V.B.command though anything would be better than nothing!

thanks in advance

jamie

 

[Talismanic]

Use a form and a subform and link the two forms with the company name. Set the subforms enabled properties to false to keep the records from being entered. You could also lock the fields you want to instead of the entire form

On the main form you want one combo box with the available company names for your list. You could make a query based on the company table to get that done. On the subform you can put all the fields you want to see. The subform will be updated evertime the company name in the main form changes as long as they are linked correctly.

That is how you do it with out code.

 

[Jack Cowley]

Create a form based on the Company table. Put the fields you want to see from the Company table on the form. When you have all the fields you want create a Combo box using the Wizard. On the Wizards first screen select the third item, "Find a record....". Now when you select the company you want from the Combo box the related data will be displayed in the appropriate text boxes.

Hope this is what you are after....

 

[Cedwards]

Thanx Jayk it worked well. Cheers