Combo Box Search?

  • Thread starter E-mail report using Lotus Notes rather t
  • Start date
E

E-mail report using Lotus Notes rather t

Hi,

I have a combo box where my user will selec the item they have questions on
and will open a form called "Faqlist". On this form I also have label from
the combo box list such as "How to Export?" What I want to do is when the
user select the FAQ question from the combo box, it will automatically find
the label in my form "How to Export?" but i want it highlight so my user will
be able to see it quickly rather than scrolling down the form to look for the
label heading. The FAQ form is not connected to a table. It is made of only
"Labels" (box with title on it). Would the "setfocus" work it's not tied to
a table? Thanks.

Private Sub Combo34_AfterUpdate()
If Me.Combo34 = "How to Export" Then
DoCmd.OpenForm "faqlist", acNormal, "", "", , acNormal
End If
If Me.Combo34 = "Save registration request" Then
DoCmd.OpenForm "faqlist", acNormal, "", "", , acNormal
End If
End Sub
 
O

Ofer Cohen

First about your code, if you open the same form, then use one IF

Private Sub Combo34_AfterUpdate()
If Me.Combo34 = "How to Export" Or Me.Combo34 = "Save registration request"
Then
DoCmd.OpenForm "faqlist", acNormal, "", "", , acNormal
End If
End Sub
*****************
The SetFocus wont work on a lable, but you can create a text box and make it
look as a lable, and the text box can get the focus, and it doesn't need to
be bound to a field in the table.

About the color of the text box, you can use the Conditional formating to
make in color different by the selection of the combo
 
E

E-mail report using Lotus Notes rather t

Hi Ofer,

I have been following your instructions to play with text box but I can't
figure it out. Can you give me a little more detail how I can make the text
box act as a label and no table attached to it. Thanks.
 
Top