By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,136 Members | 1,089 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,136 IT Pros & Developers. It's quick & easy.

Syntax help with requery command

P: n/a
Hello,

I do not have a good hold on the syntax could you please help me
requery a field with updates from a closing update from.
Form: GeneralInfo
Field: CustomerLocation (lookup from qry_CustLocationID)
Button "Add new Location"
open a Form "frm_CustLoc" in the add mode.

When I close the frm_CustLoc in need to update(requery)
CustomerLocation field.

Thanks

N. Graves
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
N. Graves wrote:
Hello,

I do not have a good hold on the syntax could you please help me
requery a field with updates from a closing update from.
Form: GeneralInfo
Field: CustomerLocation (lookup from qry_CustLocationID)
Button "Add new Location"
open a Form "frm_CustLoc" in the add mode.

When I close the frm_CustLoc in need to update(requery)
CustomerLocation field.

Thanks

N. Graves


In your OnClose event of the frm_CustLoc you could enter
Forms!GeneralInfo!CustomerLocation.Requery

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.