tryimg to customize a report based on the current form's text boxes 2

[miscluce]

I am tryimg to customize a report based on whats in the current form's text boxes or combo boxes.

I have a form with a combo box on it and a button. When the user clicks the button a report opens.

on the report is a texbox with the
control source property ="=[Forms]![frmName]![Combo22]"

But it is not displaying the word that is currently showing in the combo box from the form, it displays a number 1???

Does anybody know how I can correct this?

 

[miscluce]

I figured its something to do with the combo box because I can put a text box on a report and get that to work like I wanted.

like this:
textbox control soource on report is:

control source="=[Forms]![frmName]![txtLastName]

 

[RuralGuy]

You are accessing the Bound Column of the ComboBox rather than the Column that is displayed. Try:
"=[Forms]![frmName]![Combo22].[Column(1)]" for the 2nd column.

HTH RuralGuy (RG for short) acXP winXP Pro
Please respond to this forum so all may benefit

 

[miscluce]

I tried it and that gives me this output:

#NAME?

cant I use the expression builder to do this?

 

[RuralGuy]

How about:
"=[Forms]![frmName]![Combo22].[Column](1)"
...now it is simply a syntax problem.

HTH RuralGuy (RG for short) acXP winXP Pro
Please respond to this forum so all may benefit

 

[miscluce]

got it. thanks.

 

[RuralGuy]

Great. Thanks for posting back.

HTH RuralGuy (RG for short) acXP winXP Pro
Please respond to this forum so all may benefit

 

[Prattdakota]

Thanks, this post helped me today too.

 

[missinglinq]

That would be RG, MVP, would it not?

;0)>

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[RuralGuy]

You're right Linq. I guess I need to change my sig here as well. ;-)

HTH RuralGuy (RG for short) acXP winXP Pro
Please respond to this forum so all may benefit

 

[missinglinq]

You shouldn't hide your candle under a bush; you've seen what that caused in Southern California!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[RuralGuy]

Thanks for the reminder Linq.

RuralGuy (RG for short) aka Allan Bunch MS Access MVP acXP winXP Pro
Please respond to this forum so all may benefit