A form problem

[ericb]

On my main form, Home Base, is a subform that shows me a list of persons. I
have a set of command buttons that make different report for the selected
person. That works fine.

What I need to do is a command button that modifies the list, Ex : 30 days,
60 days 90 days. I click the 30 days button and the list will be composed of
the people that I saw in the last 30 days.

I can make a query and all for that but I can't manage to simply update (or
requery) the list with the selected filter (or query) without changing the
hole screen.

How can I update the present subform without having to change the entire
screen ?

Thank's for the help

 

[Dirk Goldgar]

On my main form, Home Base, is a subform that shows me a list of persons.
I
have a set of command buttons that make different report for the selected
person. That works fine.

What I need to do is a command button that modifies the list, Ex : 30
days,
60 days 90 days. I click the 30 days button and the list will be composed
of
the people that I saw in the last 30 days.

I can make a query and all for that but I can't manage to simply update
(or
requery) the list with the selected filter (or query) without changing the
hole screen.

How can I update the present subform without having to change the entire
screen ?

I don't understand what you mean by "change the entire screen". If you can
define filter criteria that select the desired subsets of people, I would
expect your buttons to just modify the subform's .Filter and .FilterOn
properties, and I don't see how that would "change the entire screen".

Another alternative is to change the subform's .RecordSource property, and
again I don't understand what that might do that your don't want it to.

Could you please show the code you're trying to use, and explain exactly
what it does that you don't want it to do? Are the command buttons in
question on the main form or on the subform?