Selecting certain records to display in an unbound combo box

[MattCollins]

Ok sorry to be a pain

I have a main form frmProperty from where you can go via a button to frmTraining and these two are linked by "Property Code".

On frmTraining i have an unbound combobox which gets it data from the tblTraining table. I want this to only display data for the "Property Code" that the frmProperty is pointing to.

I assumed this would just work if the link criteria was present in the button code, however it appears that no matter what the "Property Code" the combo box displays all the data in the tblTraining table.

Anybody have any ideas?

Many thanks

 

[MattCollins]

Ok have fixed this by basing the tblTraining on a query and using


[Forms]![Property]![PropertyCode]

in the "property code" criteria of tblTraining