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

ms access report /letter

P: n/a

I am creating a report / letter that automatically fills in fields from
a form when a command button is pressed on the form.....
The idea is to create a report /letter containing member address and
specific vehicle details from data displayed on form... (member can
have many vehicles and specific vehicle is selected from second tab
section (subform ?)of form

I have a form with two tab pages on it and data is required from both
sections.
First tab section has member details
Second tab section has an embedded form (subform ?) with vehicle details
and is tied to member info...

Problem :..... I can create fields for report/letter from first form
tab section ( =Trim(Forms!Form1!Firstname & " " &
Forms!Form1!SURNAME)...etc ) without any problems......
BUT can not get relevant vehicle details from second tab section
(subform - AUTOLIST_1)to display on report /letter...

Can some one put me on the correct path...????
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Try:
=[Forms]![Form1]![AutoList_1].[Form]![SomeTextBox]

If that does not work, open the main form in design view.
Right-click the edge of the subform control, and choose Properties.
Check the Name property (Other tab of properties box).

The Name of the subform control can be different from its SourceObject.

The name of the tab control does not come into the reference.
If the ".Form" bit is new, see:
Referring to Controls on a Subform
at:
http://members.iinet.net.au/~allenbrowne/casu-04.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"John Young" <ja*****@arach.net.au> wrote in message
news:41**********************@news.newsgroups.ws.. .

I am creating a report / letter that automatically fills in fields from
a form when a command button is pressed on the form.....
The idea is to create a report /letter containing member address and
specific vehicle details from data displayed on form... (member can
have many vehicles and specific vehicle is selected from second tab
section (subform ?)of form

I have a form with two tab pages on it and data is required from both
sections.
First tab section has member details
Second tab section has an embedded form (subform ?) with vehicle details
and is tied to member info...

Problem :..... I can create fields for report/letter from first form
tab section ( =Trim(Forms!Form1!Firstname & " " &
Forms!Form1!SURNAME)...etc ) without any problems......
BUT can not get relevant vehicle details from second tab section
(subform - AUTOLIST_1)to display on report /letter...

Can some one put me on the correct path...????

Nov 13 '05 #2

P: n/a

Allen
Thanks for that.... problem solved .... I was on right track
but did not think of the ... [AutoList_1].[Form]... "dot" connection for
the form..

help much appreciated and will look at your helpfull link

Cheers

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

This discussion thread is closed

Replies have been disabled for this discussion.