Greetings,
I am trying to trap when a record is created or
deleted via my subform.
Out of the 6 or so controls bound to the 6 fields
in my table, I only want 3 to allow user input.
My problem is that initially I only want 1 of the
3 user input fields available initially. Once
they choose the primary key, and the 3 non-user
enterable fields have been retrieved, they can
adjust the remaining two user input fields.
In my case, I have the Part_Number, Order_Type,
Qty, Description, Price, and Line_Total. The last
three of these are the ones that are disabled (data
will be shown/calculated but not enterable by the user).
Order_Type & Qty wont be enabled until they choose a
Part_Number.
The problem is that, once they choose a Part_Number,
the Order_Type & Qty fields are always enabled. I
want to be able to trap an event (if such events
exist) that will tell me when they cancel the entry
of a new record (for example hit ESC), or start a
new record (so they will be starting a new one, and
the Order_Type & Qty should be disabled again until
another Part_Number is chosen).
Does such an event(s) exist? Or does anyone have any
suggestions on how to implement this?
Regards,
Tj
I am trying to trap when a record is created or
deleted via my subform.
Out of the 6 or so controls bound to the 6 fields
in my table, I only want 3 to allow user input.
My problem is that initially I only want 1 of the
3 user input fields available initially. Once
they choose the primary key, and the 3 non-user
enterable fields have been retrieved, they can
adjust the remaining two user input fields.
In my case, I have the Part_Number, Order_Type,
Qty, Description, Price, and Line_Total. The last
three of these are the ones that are disabled (data
will be shown/calculated but not enterable by the user).
Order_Type & Qty wont be enabled until they choose a
Part_Number.
The problem is that, once they choose a Part_Number,
the Order_Type & Qty fields are always enabled. I
want to be able to trap an event (if such events
exist) that will tell me when they cancel the entry
of a new record (for example hit ESC), or start a
new record (so they will be starting a new one, and
the Order_Type & Qty should be disabled again until
another Part_Number is chosen).
Does such an event(s) exist? Or does anyone have any
suggestions on how to implement this?
Regards,
Tj