Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Record Create/Delete Event?

Status
Not open for further replies.

BigTeeJay

Technical User
Jun 13, 2001
106
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top