form/subform doesnt works

G

Guest

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]+"*"

when doubleclick on the RESULTS form, the Enter Parameter Value appear wich
is normally due i need to put my searched word and the query works fine.
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]+"*"));

My issue is that when i tried to open this form RESULTS like a subform of
MAIN, dont appear nothing and i dont know how can fix it.

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
End If

flag01:
textbox_x.SetFocus

End Sub


Somebody can help me with this?

Regards
 
G

Guest

thx Katrina, but i dont receive answer after wrote the afterupdate event

Katrina said:
try subform.requery
I also replied to your other post.

Katrina

Mr Doggo said:
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]+"*"

when doubleclick on the RESULTS form, the Enter Parameter Value appear wich
is normally due i need to put my searched word and the query works fine.
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]+"*"));

My issue is that when i tried to open this form RESULTS like a subform of
MAIN, dont appear nothing and i dont know how can fix it.

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
End If

flag01:
textbox_x.SetFocus

End Sub


Somebody can help me with this?

Regards
Click to expand...
Click to expand...
 
G

Guest

Katrina i love you. works excellent!!!!!!

now, if possible that result appear with this word in bold in each registry?

regards
 
K

Katrina

If I am reading this correctly, you want only your search string to appear
in Bold, when the subform is refreshed, right? There is a way to do it, I
think. Let me see what I can find.


Katrina
Mr Doggo said:
Katrina i love you. works excellent!!!!!!

now, if possible that result appear with this word in bold in each registry?

regards

Mr Doggo said:
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]+"*"

when doubleclick on the RESULTS form, the Enter Parameter Value appear wich
is normally due i need to put my searched word and the query works fine.
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]+"*"));

My issue is that when i tried to open this form RESULTS like a subform of
MAIN, dont appear nothing and i dont know how can fix it.

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
End If

flag01:
textbox_x.SetFocus

End Sub


Somebody can help me with this?

Regards
Click to expand...
Click to expand...
 
G

Guest

Exactly Katrina...
I know that u can

thx in advance

Katrina said:
If I am reading this correctly, you want only your search string to appear
in Bold, when the subform is refreshed, right? There is a way to do it, I
think. Let me see what I can find.


Katrina
Mr Doggo said:
Katrina i love you. works excellent!!!!!!

now, if possible that result appear with this word in bold in each registry?

regards

Mr Doggo said:
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]+"*"

when doubleclick on the RESULTS form, the Enter Parameter Value appear wich
is normally due i need to put my searched word and the query works fine.
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]+"*"));

My issue is that when i tried to open this form RESULTS like a subform of
MAIN, dont appear nothing and i dont know how can fix it.

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
End If

flag01:
textbox_x.SetFocus

End Sub


Somebody can help me with this?

Regards
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

form / subform issue 3
Update subform with combobox change on main form 1
Set focus in a specific record within a subform 1
VBA Syntax for subform record source change 6
filtering a form based on the values of a subform 0
query value subform 3
Datediff on form and subform 6
Subform dependent combo box 4

Top