Form / Sub Form link

[Andy Roberts]

I have a form based on a table called tblProgress where such fields as name,
date, weather conditions and street name are stored.

I then have a subform on this form which deatils each house on the street.
The subform is based on a table called tblHouses.

Each house is assigned to a street and the idea is that each person is to
log the house they call at each day, so they enter their name, the date and
the weather (all from cbo boxes). Then on the sub form they pick the house
from a cbo box and enter the information about that house like no of
bedrooms, no of levels etc.

What I need it to do is filter the cbo box on the subform based on the
street selected on the mainform. I can sort one cbo based on another when
they are both on the same form but how do you do it when one is on a
mainform and the other on a subform?

Andy

 

[Al Campagna]

Andy,
Use this crieria in your subform combo, against the Street field... (use your own
object names)
=Forms!frmMain!Street
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Guest]

The system won't allow me to start a new question but this seems related - so
I'm hoping someone can help...

I have a fmain form with some checkboxes, etc. that people can do data entry
to with 3 subforms for different products, keywords etc (multiple selections
allowed in each).

I want to build a filter so, if on the main form, someone chooses the State
TN and then from the subform a keyword like Civil Rights and runs the filter
and will get ONLY the records with TN and Civil Rights. Now I get all the TN
records - regardless of if Civil Rights is also selected.

I'm stumped.

Lydia