Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Access Training and help » Controlling a subreport

Controlling a subreport

ResolvedVersion 2007

Wed 30 Nov 2011, 15:19 Delegate Danny said...

Danny has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course

Controlling a subreport

Hi

I have a list of my clients in list/option box, using on the onClick property i would like a macro to change the record to a linked record on a subreport relative to the client i had selected

thank you

dan

Tue 6 Dec 2011, 09:08 Trainer Simon said...

RE: controlling a subreport

Hi Danny,

Thank you for your question.

I will have a look at some code I have at home and see if I can send you it tomorrow morning.

The code will be generic but you should be able to edit it to match your requirements. Have you attended the Access VBA course with us? If so, they should be some similar code that you may be able to adapt.

Regards

Simon

Access tip:

Prefixed Autonumbering

When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.

For example, P001, where P is the prefixed letter

Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Controlling a subreport

Controlling a subreport

RE: controlling a subreport

Access articles

Access tip:

Prefixed Autonumbering