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

How to attach an SQL statement to an unbound control????

P: n/a
Hello:

How do you attac an SQL statement to an unbound forms (or reports)
control in A2002?

I created an unbound text box, and I want to attach the following SQL
statement.....
select count(node) from b321bl where stdverifyby = 'test'
I have several of these to add to this form, so I would really
appreciate your help. Yes, I tried ....
=select count(node) from b321bl where stdverifyby = 'test'
in the "Record Source" property and it would not compile.

Thanks for any ideas.

Richard Hollingsworth

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Try using the DCount function

=DCount("Node", "b321b1", "stdverifyby='test'")

You can replace the field name, Node, with * depending on the count you
need.

--
Wayne Morgan
MS Access MVP
"Richard Holliingsworth" <wi*******************@boeing.com> wrote in message
news:Ht********@news.boeing.com...
Hello:

How do you attac an SQL statement to an unbound forms (or reports)
control in A2002?

I created an unbound text box, and I want to attach the following SQL
statement.....
select count(node) from b321bl where stdverifyby = 'test'
I have several of these to add to this form, so I would really
appreciate your help. Yes, I tried ....
=select count(node) from b321bl where stdverifyby = 'test'
in the "Record Source" property and it would not compile.

Thanks for any ideas.

Richard Hollingsworth

Nov 12 '05 #2

P: n/a
Apply the SQL to the controls ControlSource property. For combos and
listboxes use the RowSource property.

Mike Storr
www.veraccess.com

"Richard Holliingsworth" <wi*******************@boeing.com> wrote in message
news:Ht********@news.boeing.com...
Hello:

How do you attac an SQL statement to an unbound forms (or reports)
control in A2002?

I created an unbound text box, and I want to attach the following SQL
statement.....
select count(node) from b321bl where stdverifyby = 'test'
I have several of these to add to this form, so I would really
appreciate your help. Yes, I tried ....
=select count(node) from b321bl where stdverifyby = 'test'
in the "Record Source" property and it would not compile.

Thanks for any ideas.

Richard Hollingsworth

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.