Hello anyone any idea how to do this.
The problem I am having has to do with Continuous Forms.

In the header of the form I have 4 Combo boxes. For now lets just work on one combo box. The combo box name is 'PYID'. The table name is 'Invoice' and the field name is 'PYID' and that field is column 3. Thats if in access columns start at 0.

OK What I want to do is this, when a user selects a value from PYID combo box...