At runtime - changing the data control source of a textbox in a re

D

Dan Zweig

For each record in my data, I have office priorities stored for a couple
dozen offices.

For each recrod on the report, I have space to show priority for six of the
offices, with the offices chosen by the user in a form.

Lets reduce this problem to wanting to show for each record a choice of 2
office's priority value out of 5 possibilities.

Possibilities are in fields Offices_A through Offices_E.

Textbox controls on report are Office1_Priority and Office2_Priority.

I open the report using a DoCmd.OpenReport function.

How do I set the data control source for the Office1_Priority and
Office1_Priority fields?

Dan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set Control source at runtime 2
Growable Text Box in Report 2
Reflect Control Source Change via VBA 4
Which control should I use to display query data on a form? 8
Running SQL SELECT statements in Access runtime 2
Changing Project Priorities 2
Combine Reports 1
Change Report Footer control's controlsource in VBA 1

Top