layering text field over combo box

  • Thread starter Thread starter mharness
  • Start date Start date
M

mharness

Hello,

I'm using a combo box in a subform from which the user can only see and pick
items that are current. I have layered a text field of that saved choice
over the combo box so that the record of the item still appears even though
the item is no longer current.

I'm not really that crazy about this solution but it's the best I can come
up with so far to keep the contents of the combo box short and current. The
main problem is that when the form is loaded, the text box is hidden behind
the combo box in the first record of the subform. I have tried moving the
text field to the front in design view but it has no effect on the first
record in form view.

Does anyone have a solution for dealing with this problem or can someone
suggest a better way all together?

Thanks,

Mike
 
I can't reproduce that behavior. My combo stays in the back until I give it
focus. You might be able to overcome your problem by adding a line of code
to set the focus to the text box when the form opens:

Sub Form_Open()
Me.txtWhatever.SetFocus
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top