Thnks for your feedback 'Anon'. I want to be able to do it with buttons. I
have pasted the same, but fuller version of what I am trying to do, any help
would be greatly appreciated.
I want to show a Form (On either a tab bar or subform) linked to a query that
shows overdue invoices based on 3 buttons on the form. The 3 Buttons are
30,60,90 days. Whichever one is pressed will requery and only show those
records. When I place a custom form (on the main form) that corretly runs the
queries outside of the main form, it doesn’t work. When I press one of the
sort buttons, it asks for a parameter for ‘Invoices Overdue
Query.DaysOverDue’. What am I doing wrong?, Is it possible to run a subform,
not as a subform, but as a separate form on the main form linked to the query?
-----Original Message-----
I need to be able to sort on overdue invoices, 30/60/90 days from a single
Query, but I can't get the Form to requery using a new criteria such as: >29
And <61. The form throws an error asking 'Enter Query Parameter'. Am i going
about this the wrong way?
.
you could try puting a text box on your form calling it
periodoverdue.
lets say your form is called myform.
then the criteria on you query would be.....
forms![myform]![periodoverdue]
run this from the afterchange property of your text box.
or if you wanted all overdue records the critera would
be : between 29 and 61
