Automation / Validation 2 page fields single report

[ConfusedNAccess]

Does anyone know if there is a way.. or code or something that exists.. that if my report has 2 page fields.. and one of the page fields is selected, it will prompt... or update / refresh the corresponding page field on the same report????

for instance.. 2 page items are STATE, CARS, row field is MODEL and COLOR...

so if i select the state field, it will validate the next page field to the different "cars" options.. therefore if the choices were TOYOTA, HONDA.. etc.. it would updating the data to reflect the different models and colors of the car I chose???

I hope that makes sense to someone.. I NEED HELP!!!

 

[fneily]

If this is an Access question, please post in one of the 7 Access forums such as Microsoft: Access Reports.
If it is about Access then no.
Reports can be looked on as a piece of paper - you can't update a piece of paper. What you want to do is from a FORM have the user select the options they want and THEN produce a report.
Do that first then post in the proper Access forum.

 

[ConfusedNAccess]

This is Excel Question Pivot Report Question