A
Adam
You replied to my post earlier and you told me to type
some code somewhere, i made an expression like that in
expression builder earlier, but it didn't work.
You can use a Criterion of
= [Forms]![NameOfYourForm]![NameOfTheListbox]
to have the query look to the form control for the
searched value. You
will probably need to Requery the subform in the
AfterUpdate event of
the listbox.
I have attached a screenshot of where i put the code and
pics of the rest of my database.
I have put the code you said into the criteria box in the
query and it refers to the listbox in the form which i
attached also, the subform in the mainform is the query i
am using. The table i have attached is the table which the
query refers to.
I want the subform table to update when i select a name in
the listbox in the form.
Here are the links to the pictures:
http://sniperit.20m.com/cgi-bin/i/Access/Query.jpg
http://sniperit.20m.com/cgi-bin/i/Access/Table.jpg
http://sniperit.20m.com/cgi-bin/i/Access/form.jpg
Am i doing this right?
Please help.
Thankyou
Adam
some code somewhere, i made an expression like that in
expression builder earlier, but it didn't work.
You can use a Criterion of
= [Forms]![NameOfYourForm]![NameOfTheListbox]
to have the query look to the form control for the
searched value. You
will probably need to Requery the subform in the
AfterUpdate event of
the listbox.
I have attached a screenshot of where i put the code and
pics of the rest of my database.
I have put the code you said into the criteria box in the
query and it refers to the listbox in the form which i
attached also, the subform in the mainform is the query i
am using. The table i have attached is the table which the
query refers to.
I want the subform table to update when i select a name in
the listbox in the form.
Here are the links to the pictures:
http://sniperit.20m.com/cgi-bin/i/Access/Query.jpg
http://sniperit.20m.com/cgi-bin/i/Access/Table.jpg
http://sniperit.20m.com/cgi-bin/i/Access/form.jpg
Am i doing this right?
Please help.
Thankyou
Adam