Access 2007 - Enable Field Query

I have a form with a sub-form within.

The main form consists of 3 fields. The first is a combo box "Materials/Description of Work", the second is "Unit of Measure" and the third is "Quantity".

I would like the combo box to disable itself once I tab to the sub-form - this is to prevent accidentally changing the selection in the combo box.

When I go to a new record I would like the combo box to be re-enabled so I can make a new selection.

I am only now learning how to write code so I need all the help I can get.

Thanks in advance for your input

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!