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

Passing Unbound Data to a Query

P: 18
Would the experts please indicate how to pass unbound control data to a query?

When I pass a bound field from a combo box to my select query, everything is fine; when I change the combo box to an unbound box (so that the underlying table is not updated with a new record) the query receives an empty string.

Incidentally, is there a wizard in ACC2003 for creating a query using a control from a form? That would be delicious.
Jun 8 '07 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 10K+
P: 12,441
To refer to a control on a form from a query, use: [Forms]![Form Name]![Control Name]
Jun 8 '07 #2

P: 18
Thanks for the response.

Turns out the wrong column was called out in the properties box (the wizard always likes to use the primary key field for some raisin).
Jun 11 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.