Display combo box as test box

[foxtet]

Hi Guys!

Good Day for all.

I have a small database in which I have a search form. When I double click the search form MAWBNo field frmCargoMaster opens. I want combo boxes in that form to be displayed as text boxes.

I tried to do that but still Im not able to get this done. Any bright minds out there why not solve this for me.

The sample db is attached

foxtet

 

[foxtet]

Hi Uncle Gizmo,
Can I have practical example with the attached DB.

foxtet

 

[gemma-the-husky]

do you want the combo boxes to work?

if not, then just bind the lookup in the query, and use a text box.
or enable=false, lock=true, and they won't be able to use the combobox.

 

[foxtet]

What event opens the form?

Double click event of sub form.

 

[foxtet]

I can think of two ways I've seen this done in the past. The first way is to actually have two controls, a combobox and textbox.

When you open the form you can pass a signal through the open args to hide the combo boxes or the text boxes, depending on what you are using your form for.

The other way is to have a label which covers the Down arrow on the combobox. This is better if you want to keep the combobox functionality, just lose the look of a combobox.

It worked!
Thanks