How to requery from a form

S

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
 
O

Ofer Cohen

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

i_takeuti

Simon said:
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
Click to expand...
 
Top