data from query

[Cass]

1.)
I want use in Report Can Grow and Can Shrink. Now if in guery, where is the Report data, is specified word in column then Grow and everything else Shrink report Header1 panel

Found the solution how it works with msgbox (yes/no) but how i make clear to take the value in query?

2.)
How to use data whatsoever query/table in vba? (table!.....?)



I'm not so good in VBA and english but i want learn both

 

[david.brent]

Cass,
If I'm right, you want the look of the report to change based on a value in a recordset (query/table). Example. If Field1="Hello" you might want the header to be hidden but if Field1="Goodbye" you might want the header to be visible?

Let me know if this is what you want. If I've got your meaning wrong then try to post again I tell us what is needed.

Regards
Carl.