Simple yet frustrating question 1

[DD999]

Is there an easy way to filter records in a form based on a selection from a combo box?

I have a table called tblSystems. I want to choose a sysID from it using a combo box.

I then want this selection to populate the other fields from the same table on the form.

Lastly, tblSystem is linked to another table called tblEnvironments, which in turn is linked to tblEnvDetails.

I would like to have the corresponding records in these tables (which are displayed in subforms)update whenever the combo box selection is changed.

There must be an easy way that I'm just not seeing.

Thanks

 

[Trendsetter]

There are a number of ways of doing what you want but I think the easiest is to reference your combo in the query feeding the form. If you pur the address of the combo in the criteria of the key field of the query then every time the combo changes and the form is requeried the appropriate record will appear in the form.
If you are not sure how to do this I can send you a sample if you need it, just let me know.

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk