Unbound Combo Boxes - how to link into a report?

[Glencannon4424 via AccessMonster.com]

Hello,

I have a form with 2 combo boxes, ID and PW-Title, which are driven off 2
tables. Whatever the user selects in ID and PW-Title will auto-populate 2
other boxes, Hire-Date and PW-Rate. My form works perfectly (or seems to
anyway).

I built a report which is supposed to run off my selections for ID and PW-
Title. But, regardless of which ID or PW-Title I select, the report always
produces results for the 1st ID and 1st PW-Title in my tables; the Hire-Date
and PW-Rate, however, mirror my selections in the form. I've using the same
scripts for all 4: =[Forms]![INPUT]![ControlSource].

What am I doing wrong? Thanks very much in advance . ..

 

[Jeff Boyce]

When you say you have a return that "runs off your selections", how? Please
post the query (or code) you are using that is supposed to be using the
combo boxes.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Glencannon4424 via AccessMonster.com]

Never mind, figured it out on my own.

Hello,

I have a form with 2 combo boxes, ID and PW-Title, which are driven off 2
tables. Whatever the user selects in ID and PW-Title will auto-populate 2
other boxes, Hire-Date and PW-Rate. My form works perfectly (or seems to
anyway).

I built a report which is supposed to run off my selections for ID and PW-
Title. But, regardless of which ID or PW-Title I select, the report always
produces results for the 1st ID and 1st PW-Title in my tables; the Hire-Date
and PW-Rate, however, mirror my selections in the form. I've using the same
scripts for all 4: =[Forms]![INPUT]![ControlSource].

What am I doing wrong? Thanks very much in advance . ..

 

[Jeff Boyce]

Consider posting back what you figured out -- other newsgroup readers may
benefit from what you did...

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Never mind, figured it out on my own.

Hello,

I have a form with 2 combo boxes, ID and PW-Title, which are driven off 2
tables. Whatever the user selects in ID and PW-Title will auto-populate 2
other boxes, Hire-Date and PW-Rate. My form works perfectly (or seems to
anyway).

I built a report which is supposed to run off my selections for ID and PW-
Title. But, regardless of which ID or PW-Title I select, the report always
produces results for the 1st ID and 1st PW-Title in my tables; the Hire-Date
and PW-Rate, however, mirror my selections in the form. I've using the same
scripts for all 4: =[Forms]![INPUT]![ControlSource].

What am I doing wrong? Thanks very much in advance . ..

 

[Glencannon4424 via AccessMonster.com]

I'm not entirely sure what didthe trick . . . .

I changed the order of my inputs in the 'row source control'
I changed the bound column number
I changed the control source field in the auto-populated cells so that the
name matched my unbound cell.

The combination did the trick . .

Consider posting back what you figured out -- other newsgroup readers may
benefit from what you did...

Never mind, figured it out on my own.

[quoted text clipped - 12 lines]