Customise Combo box

[TiggR]

I am hoping to be able to use the properties of a combo box but without it actually providing the list selection. Basically I want to use a combo box with the rowsource and recordset defined by code but I want it to display like a text box. It would appear as a text box but be able to autofill as it will have a datasource defined. I hope I have explained myself properly and I hope someone can help, personally I thought it would of been easy to turn off the dropdown property.

Please someone help me, I would be eternally grateful.

Doug

 

[simongallop]

Thought about using a listbox instead? You will still have the scroll bar if there is more than one record but it won't dropdown.

 

[TiggR]

I have thought of that but I really want to try to make it look just like a text box, but with autofill properties.

Thanks for your input anyway.

Doug

 

[Pat Hartman]

Add the "look up" table to the form's recordsource query with a join to the main table and include the additional fields in the select clause. Access will then autofill a bound textbox. If you don't want these "look up" columns to be updateable on this form be sure to set their control properties to locked = yes and enabled = no.

 

[TiggR]

Thanks for the suggestion Pat, but Im not sure if that will work in this instance as Im using all unbound boxes and the recordsource has been isolated so they dont work on live data.

Why is this so complicated? Please keep the suggestions coming.