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

Select all from subform

P: n/a
Hi, how can i select every record from a subform that matched to my
searching criteria ? i tried to use SQL select and "[field]= '" &
forms!xxx!xxx.form!field & '"" but it will only select first record
that matched. Anyway to select every record that matched ? Thanks.

Regards,
Daniel
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
tom
Daniel,
I'm confused about what you're attempting to accomplish. The word
"select" could mean several things in this context. Please clarify
what your goal is here. Also, some specifics would help out too.

-Tom

da*******@time.net.my (Daniel Tan) wrote in message news:<6a**************************@posting.google. com>...
Hi, how can i select every record from a subform that matched to my
searching criteria ? i tried to use SQL select and "[field]= '" &
forms!xxx!xxx.form!field & '"" but it will only select first record
that matched. Anyway to select every record that matched ? Thanks.

Regards,
Daniel

Nov 12 '05 #2

P: n/a

Hi Tom,

I mean that i want all the records available in my subform to be
generated in a report. Whatever records there i want to generate a
report based on it. Thanks

Regards,
Daniel

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #3

P: n/a
Daniel Tan <da*******@time.net.my> wrote in message news:<40***********************@news.frii.net>...
Hi Tom,

I mean that i want all the records available in my subform to be
generated in a report. Whatever records there i want to generate a
report based on it. Thanks

Regards,
Daniel


Then couldn't you filter for the Primary Key from the main form?

DoCmd.OpenReport "MyReport","MyPrimaryKey=" & Me!txtMyPrimaryKey

or something along those lines...
Nov 12 '05 #4

P: n/a
Well , it generate all the records instead of the records in the
subform. i thought it would but then it wouldn't.

DoCmd.OpenReport "custorder", acViewPreview, "[job_order]=
Forms!main!Overdue_sub.Form!Jobid

Regards,
Daniel

pi********@hotmail.com (Pieter Linden) wrote in message news:<bf**************************@posting.google. com>...
Daniel Tan <da*******@time.net.my> wrote in message news:<40***********************@news.frii.net>...
Hi Tom,

I mean that i want all the records available in my subform to be
generated in a report. Whatever records there i want to generate a
report based on it. Thanks

Regards,
Daniel


Then couldn't you filter for the Primary Key from the main form?

DoCmd.OpenReport "MyReport","MyPrimaryKey=" & Me!txtMyPrimaryKey

or something along those lines...

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.