Select Query with conditions not working

[Guest]

Hi - I have a query which is designed to pull a list of Volunteers for the
Region that has been selected in the Region field in the Switchboard Form.
There are 130 Regions and the Region field [named RegionComboforVolunteers]
sources the list from the Region Table.

I have 2 databases almost identical - set up to manage 2 different campaigns
for 2 different clients. My query works for one db though not for the other.

My problem is that when I go to run the query I have pop up box telling me
to enter the parameter value .....
[Forms]![Switchboard]![RegionComboforVolunteers].

Any help would be greatly appreciated --
Sue Compelling

 

[Douglas J Steele]

The query is expecting that there's a form named Switchboard open when it
runs, and that that form has a control on it named RegionComboforVolunteers.
It's using the value in that control to limit what's returned.

Do you have that form and that control in both databases? Is the form open
when you're running the query?

 

[Guest]

Hi Douglas,

Yes to both [Form is Open; Control and Form in both databases]. The user
selects the Region from the Switchboard then hits a command button right
beside it which runs the query and should produce the report. If the user
cuts the name from the 'RegionComboforVolunteers' and pastes it into the
pop-up box prompt; the report gets produced, though this is very clumsy.
Also - thanks for the assistance on the maximizing the start up screen -
brilliant.
--
Sue Compelling

The query is expecting that there's a form named Switchboard open when it
runs, and that that form has a control on it named RegionComboforVolunteers.
It's using the value in that control to limit what's returned.

Do you have that form and that control in both databases? Is the form open
when you're running the query?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hi - I have a query which is designed to pull a list of Volunteers for the
Region that has been selected in the Region field in the Switchboard Form.
There are 130 Regions and the Region field [named RegionComboforVolunteers]
sources the list from the Region Table.

I have 2 databases almost identical - set up to manage 2 different campaigns
for 2 different clients. My query works for one db though not for the other.

My problem is that when I go to run the query I have pop up box telling me
to enter the parameter value .....
[Forms]![Switchboard]![RegionComboforVolunteers].

Any help would be greatly appreciated --
Sue Compelling

 

[Guest]

Douglas - you're a saviour. I just fixed up my maximize command [from your
previous post] and found a whole lot of errant 'event procedures'. I deleted
all these and now my command works. Can't tell you how thrilled I am to have
discovered this forum - it's a real lifesaver for me down here in little old
New Zealand. Thanks again.
--
Sue Compelling

Hi Douglas,

Yes to both [Form is Open; Control and Form in both databases]. The user
selects the Region from the Switchboard then hits a command button right
beside it which runs the query and should produce the report. If the user
cuts the name from the 'RegionComboforVolunteers' and pastes it into the
pop-up box prompt; the report gets produced, though this is very clumsy.
Also - thanks for the assistance on the maximizing the start up screen -
brilliant.
--
Sue Compelling

The query is expecting that there's a form named Switchboard open when it
runs, and that that form has a control on it named RegionComboforVolunteers.
It's using the value in that control to limit what's returned.

Do you have that form and that control in both databases? Is the form open
when you're running the query?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hi - I have a query which is designed to pull a list of Volunteers for the
Region that has been selected in the Region field in the Switchboard Form.
There are 130 Regions and the Region field [named RegionComboforVolunteers]
sources the list from the Region Table.

I have 2 databases almost identical - set up to manage 2 different campaigns
for 2 different clients. My query works for one db though not for the other.

My problem is that when I go to run the query I have pop up box telling me
to enter the parameter value .....
[Forms]![Switchboard]![RegionComboforVolunteers].

Any help would be greatly appreciated --
Sue Compelling