Still Need Help on Filtered Control on a Continuous Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a filtered control (Combo Box) on a continouous form where the
condition for the control is based off of a value (varies) from another field
in the same row
of data. When the value for the filtered field is selected it is displayed
fine, but when the user goes to the next row of data to make a selection the
data from the previous row disappears unless the user places there cursor
back on that row.

Any suggestions on how to make the data display always without having your
cursor on that row of data only?

Thanks for any suggestions!

Sarah
 
Sarah said:
I have a filtered control (Combo Box) on a continouous form where the
condition for the control is based off of a value (varies) from another field
in the same row
of data. When the value for the filtered field is selected it is displayed
fine, but when the user goes to the next row of data to make a selection the
data from the previous row disappears unless the user places there cursor
back on that row.

Any suggestions on how to make the data display always without having your
cursor on that row of data only?
Click to expand...


This is a tricky situation. The robust way to deal with it
is to add a text box to the form. Bind the text box to the
same field as the combo box and size/position the text box
exactly on top of the combo box's text portion. Use the
text box's GotFocus event to switch the focus to the combo
box:
Me.thecombobox.Setfocus
 
That didn't work. Still having the same problem.
Marshall Barton said:
This is a tricky situation. The robust way to deal with it
is to add a text box to the form. Bind the text box to the
same field as the combo box and size/position the text box
exactly on top of the combo box's text portion. Use the
text box's GotFocus event to switch the focus to the combo
box:
Me.thecombobox.Setfocus
Click to expand...
 
Sarah said:
That didn't work. Still having the same problem.
Click to expand...


That is a statement, probably a fact. If you have a
question, please express it clearly and provide the
background information to help us figure out what you have
tried and what resulted from the attempt.
 
Back
Top