Updating Controls

[Steven Stewart]

Hi there,

I have a report that is opened from a command button on a form. There
is a label on the report called lblProvince. I would like to be able to
change that label based on what the user selected on the form.

For instance, if the user selects "Alberta" from lstProvince, and then
the clicks on the command button (cmdNext) to open the report, I would
like the lblProvince.Caption on the report to say "Alberta."

It gets a little trickier than this but I want to understand the basic
way to do this. Where it gets tricker is this:

The user, on the form, can select a report for a Local Office, a
province, or All Of Canada. If the user has checked off "All Of Canada"
then I want the report's title to say "Canada." If the user selects a
province, then I want the title to say that province. The provinces and
local offices are listed in lstLO and lstProvince.

The "If...Then" is begging for some code, and I noticed that the report
has an open event procedure. In this event procedure, how do I check
form controls? What is the syntax?

Also, what property returns the string value of what is selected in a
listbox?

Thanks for any help! As you can tell, I am fairly new to this.

Steven Stewart

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

[David B]

Sounds like you need a combo box on your form.
Then 2 things.
1st the query that feeds your report should have in the criteria field of
1stprovince field
something like [Forms]![yourformname]![yourcomboname]

2nd instead of a label on the report put a text box and the control source will
point to the combo -same as above.
That should get you going
Ask again if you need more
HTH

David B
Hexham UK

Steven Stewart <o6***@unb.ca> wrote in message
news:3f*********************@news.frii.net...

Hi there,

I have a report that is opened from a command button on a form. There
is a label on the report called lblProvince. I would like to be able to
change that label based on what the user selected on the form.

For instance, if the user selects "Alberta" from lstProvince, and then
the clicks on the command button (cmdNext) to open the report, I would
like the lblProvince.Caption on the report to say "Alberta."

It gets a little trickier than this but I want to understand the basic
way to do this. Where it gets tricker is this:

The user, on the form, can select a report for a Local Office, a
province, or All Of Canada. If the user has checked off "All Of Canada"
then I want the report's title to say "Canada." If the user selects a
province, then I want the title to say that province. The provinces and
local offices are listed in lstLO and lstProvince.

The "If...Then" is begging for some code, and I noticed that the report
has an open event procedure. In this event procedure, how do I check
form controls? What is the syntax?

Also, what property returns the string value of what is selected in a
listbox?

Thanks for any help! As you can tell, I am fairly new to this.

Steven Stewart

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

[David B]

If you want to return all records then in an empty field of the query grid in
the top line (where the field names usually are)
put [Forms]![yourformname]![your combo name] and in the lower of the 2 criteria
boxes put - is null.
That way if the combo is blank all records will be returned
HTH
David B

Steven Stewart <o6***@unb.ca> wrote in message
news:3f*********************@news.frii.net...

Hi there,

I have a report that is opened from a command button on a form. There
is a label on the report called lblProvince. I would like to be able to
change that label based on what the user selected on the form.

For instance, if the user selects "Alberta" from lstProvince, and then
the clicks on the command button (cmdNext) to open the report, I would
like the lblProvince.Caption on the report to say "Alberta."

It gets a little trickier than this but I want to understand the basic
way to do this. Where it gets tricker is this:

The user, on the form, can select a report for a Local Office, a
province, or All Of Canada. If the user has checked off "All Of Canada"
then I want the report's title to say "Canada." If the user selects a
province, then I want the title to say that province. The provinces and
local offices are listed in lstLO and lstProvince.

The "If...Then" is begging for some code, and I noticed that the report
has an open event procedure. In this event procedure, how do I check
form controls? What is the syntax?

Also, what property returns the string value of what is selected in a
listbox?

Thanks for any help! As you can tell, I am fairly new to this.

Steven Stewart

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

[Steven Stewart]

Thanks for your help!

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