Read-Only Text Box to Update Combo Box

[Debbilynn]

I have a form (frmSysProb) tied to a table (tblSysProb). This table has the field cboEmp tied to table tblEmp for employees assigned to each system problem. I am setting up this form to open in Read-Only mode with a command button to change to Edit mode. (All is well there.) Ultimately, what I would like to see in the Read Only mode is my cboEmp data showing as a text field but when changed to Edit mode, I want the combo box back. What code would I put behind my command button to execute this?

Thanks!!!

 

[Debbilynn]

Never mind. I decided to put the combo box over the text box then set the cboEmp.visible to False and switch it out when I change over to Edit mode, and vice versa. If anyone knows of a better way, please let me know. I'll be doing this again with some other controls.

Debbilynn

 

[missinglinq]

Why do you feel the need for having the data displayed in a textbox when it's Read-only? Why not just leave the combobox? If the form is Read-only the combobox cannot be used to change the data.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!