Hi,

I have an Auto Look Up Query which works well in the Query Datasheet View. 
i.e. when I enter the value into the field on the many side (field name CRNO) 
of the join it automatically picks up the values from the table on the one 
side. 

However when I attach this Query to a form and then enter the value into the 
text box which is bound to the field CRNO of the query, values of the other 
text boxes bound to fields of the one side table via the query do not display 
any values.

If however I close the form and then return to that record, the values of the 
one side table are displayed along with the values I entered.

Could you'll kindly help me understand why this is so and what I am doing 
incorrectly ?

Thanks,

Chris

Hi Chris,

I think you'll find if you move to another record and then return to the one
you are on, you will also find that the values are updated.

You need to perform a Requery (or perhaps Refresh??) after updating the
value in your textbox. Note that after performing a requery, the first
record in your underlying recordset becomes the current record, so if your
recordset has a number of underlying records, you may need to somehow
'bookmark' the record in order to return to it.

HTH,

Andrew

-----Original Message-----
From: ccoutinho@n... [mailto:ccoutinho@n...]
Sent: Monday, 29 April 2002 5:06 PM
To: Access
Subject: [access] Auto Look Up Query not working when attached to a form


Hi,

I have an Auto Look Up Query which works well in the Query Datasheet View. 
i.e. when I enter the value into the field on the many side (field name
CRNO) 
of the join it automatically picks up the values from the table on the one 
side. 

However when I attach this Query to a form and then enter the value into the

text box which is bound to the field CRNO of the query, values of the other 
text boxes bound to fields of the one side table via the query do not
display 
any values.

If however I close the form and then return to that record, the values of
the 
one side table are displayed along with the values I entered.

Could you'll kindly help me understand why this is so and what I am doing 
incorrectly ?

Thanks,

Chris