How to requery from a form

[Simon]

I have a form that has a text box on which i would like to type some
text into then i would like it to do a requery every time i change the
text. but it not a requery on the
query the form is based on

it needs to requery on a different query


thnak

 

[Guest]

Using the After update event of text box you can write the code:
1. If the query is the record source of the main form
Me.Requery
2. If the query is the RecordSource of the SubForm
Me.[SubFromControlName].Requery

At any case the text box should be UnBound, if it will be bound to a field
in the table, it will change the value in the table and wont refresh the form

 

[i_takeuti]

I have a form that has a text box on which i would like to type some
text into then i would like it to do a requery every time i change the
text. but it not a requery on the
query the form is based on

it needs to requery on a different query


thnak