query problem

[Guest]

i have a form based query which takes the parameter from my main form and
displays the results in a sub form for billing purposes but the query will
query itself only the first time then if i go to another member it wont run
it keeps on displaying the results from the first record i updated. what can
i do to make it run each time i update the field which containes my criteria.

any help is appreciated

 

[Guest]

Hi Malcar

I am a little confused about your form structure. As I understand it you
have a main form and use one of the fields on the main form to provide the
source for a sub form. If this is the case I can't see why you are using a
parameter query to supply the data for the subform. Of course I can’t see
your form so I may be wrong.

Do you have a parent child relationship between the forms that is based on a
common data type field?

Can you give little more information regarding the fields in the form(s) and
what the parameter query actually does?

 

[Heureux-oli]

Hi malcar.

Did you try mySubForm.requery on the current event of your main form ?

 

[Guest]

Hi Wayne

My Main Form Basically collects Data Relating to members that is contact
details and date of birth which i use to assign a member to a particular age
group.

The age group Field is the parameter source for my query which gives me the
available memberships for the particular age groups i have selected, and then
i just select the particular membership i want eg 1 year membership, 6 months
membership and so on. These are displayed in a subform.

Between the two forms i have a parent child relation which is between the
members ID in my main form (Members) which is a primary key and a members ID
field in my subform (Memberships) which is a foreign key.

My problem is that if for example i have member one and he is an adult
member it gives me all the memberships in the adult category and then if i
have member 2 which is a child my query displays the previous results instead
of running again.

Also if you can help me i want to see the last record on my subform when i
open it. can you tell me how to do.

Thanks for your help.

Malcolm