Textbox instead of Combobox

**jzacharias** · 10-24-2012, 08:20 PM

Is it possible to use a textbox instead of the automatically placed combobox access creates for a lookup field? I want to create a form that just displays the information and don't need to select anything from that field.

**alansidman** · 10-24-2012, 08:34 PM

The issue is that you are doing lookups in your table. This is an Access NO-NO. Look here.

http://access.mvps.org/access/lookupfields.htm

**jzacharias** · 10-24-2012, 08:38 PM

I thought that was the only way to do a lookup. Access made it so easy. What is the alternative?

**alansidman** · 10-24-2012, 08:43 PM

Cross posted at: http://www.access-programmers.co.uk/...d.php?t=235677

**jzacharias** · 10-24-2012, 08:57 PM

Could I upload what I have so you could tell me how much "damage" I have in my table design?

Textbox instead of Combobox

Thread Tools

Textbox instead of Combobox

Similar Threads

Programming to change Combobox to Textbox on the fly

How to pass value from textbox to combobox?

On click textbox inserts value back on combobox

Filter subForm comboBox based on main form combobox selection - With a TWIST

Filter Subform ComboBox based on Master Form ComboBox selection

Posting Permissions