OK I will try and explain as easy as I can....
I have an Access form (Frm_Main) which includes two sub-forms (frm_Contracts and Frm_Repairs)
Both sub forms have a field within them called 'Frequency' which have combo boxes to enable the user to chose from a set list of values.
What I would like to do is this.....if I choose a value in the subform frm_Contracts!Frequency i.e. "6 Months", when I go to choose a value in frm_Repairs!Frequency the drop down should only allow me to choose the same value "6 Months" to populate the field, therefore both fields have always the same value.
Make any sense?
Any ideas?