M
Mr Doggo
Hi:
I've a MAIN and RESULTS forms.
I've a RESULTS query that deppend of a textbox inside MAIN form. this is the
criteria option in the query:
Like "*"+[Forms]![MAIN].[form]![textbox_x]+"*"
RESULTS form show those fields where the textbox_x value appear in the
database (field_2)
SELECT DATA.field_1, DATA.field_2
FROM DATA
WHERE (((DATA.field_2) Like "*"+[Forms]![MAIN].[form]![textbox_x]+"*"));
I've wrote this code in after update textbox_x event
Private Sub textbox_x_AfterUpdate()
If IsNull(textbox_x) Then
GoTo flag01
Else
subform.Visible = True
subform.requery
End If
flag01:
textbox_x.SetFocus
End Sub
The subform works great thanks for Katrina's help, but now i want to know if
is possible that this string appear in bold.
.... blah blah blah blah <bold>HELLO<bold> blah blah....
(HELLO in bold)
Somebody can help me with this?
Regards
I've a MAIN and RESULTS forms.
I've a RESULTS query that deppend of a textbox inside MAIN form. this is the
criteria option in the query:
Like "*"+[Forms]![MAIN].[form]![textbox_x]+"*"
RESULTS form show those fields where the textbox_x value appear in the
database (field_2)
SELECT DATA.field_1, DATA.field_2
FROM DATA
WHERE (((DATA.field_2) Like "*"+[Forms]![MAIN].[form]![textbox_x]+"*"));
I've wrote this code in after update textbox_x event
Private Sub textbox_x_AfterUpdate()
If IsNull(textbox_x) Then
GoTo flag01
Else
subform.Visible = True
subform.requery
End If
flag01:
textbox_x.SetFocus
End Sub
The subform works great thanks for Katrina's help, but now i want to know if
is possible that this string appear in bold.
.... blah blah blah blah <bold>HELLO<bold> blah blah....
(HELLO in bold)
Somebody can help me with this?
Regards