Use textbox as criteria as "more than" this figure!

[gangel]

Hey pplz


im getting the swing of access but still using macros, havent evolved into good use of vba yet

Im trying to run a query so i can open a report where "Owing" which as a currency value is MORE THAN a text box on a form.
Form = ReportMenu
Text Box = OwingMin
Query= OwingMoney
Report= RptOwing

So what i tried was having the criteria in the query to be [Forms]![ReportMenu]![OwingMin] wihch works as a single value
then i wrote >[Forms]![ReportMenu]![OwingMin] and it doesnt work at all, just gives all values... so i think im on the right track but i cant get this final step and all my googling has led me down 2 hours of frustration

Any help at all?

I appreciate it always!!!
Glenn

[June7]

Owing is field name? Is this a calculated field in query?

I never use dynamic parameterized queries. I use VBA to construct filter criteria and pass to form or report when opening:

DoCmd.OpenReport "reportname", , , "Owing=" & Me.OwingMin

[gangel]

hey June, yes it is a calculated field... im guess that will affect this?
Ill do the vba, but can i use that with calculated or use a subquery?

[June7]

Your dynamic parameter in query should work. I don't know why it fails. Would have to examine db.

The VBA approach can work with calculated fields in the form's RecordSource. What does subquery have to do with this?

[gangel]

ok i think ive got it!!!
THanks so much June, you are always the one helping me out! I'm learning heaps with your help, so just wanted you to know i aprpreciate it!

I found out i had mis spelt a textbox name in reports and i was referring to its control not its name due to that error!

I got the >textbox working now.
It is using a macro at moment but im going to covert all these to vba one at a time and learn the vba code the macro that i understand so that i can stop workingin macros