Need Order Entry form example

  • Thread starter Thread starter Jordan
  • Start date Start date
J

Jordan

I have been using a form/subform method to do an order entry system. This
has worked fine however one of the drawbacks is that if you start adding,
deleting, and editing lines in the subform there is not realy and easy
"undo" once you move to the next/previous line in the subform. I would like
to develop a form that will open the header information and the detail
information for the order, but not update the data in the back end until I
press a SAVE button.

Are there any examples of forms out there that will do this?
 
Jordan said:
I have been using a form/subform method to do an order entry system.
This has worked fine however one of the drawbacks is that if you
start adding, deleting, and editing lines in the subform there is not
realy and easy "undo" once you move to the next/previous line in the
subform. I would like to develop a form that will open the header
information and the detail information for the order, but not update
the data in the back end until I press a SAVE button.

Are there any examples of forms out there that will do this?
Click to expand...

You would have to use work tables that you temporarily copy the data into
while you work on it and then your [Save] button would run queries to apply
those changes to the real tables. A lot of extra work IMO to overcome what
should be a minor training issue for the data entry person.
 
It would be very easy for us if these users would only do what they are
supposed to do. I would only have to write about 1/4 the code I do now for
error trapping if the users would enter valid order numbers, customer IDs,
parts, etc. I only wish I could have them click every button in the right
order and pay attention to the data that they are entering.

Somehow it always seems to be our fault because "we let" the user enter data
that is totally bogus but we are also "not letting" them do their jobs if we
develop programs that are "inflexible" because we make retraints and checks
on the data to be sure they are not entering bogus data.

Unfortunately programming for the use of others requires a lot of extra
work.


Rick Brandt said:
Jordan said:
I have been using a form/subform method to do an order entry system.
This has worked fine however one of the drawbacks is that if you
start adding, deleting, and editing lines in the subform there is not
realy and easy "undo" once you move to the next/previous line in the
subform. I would like to develop a form that will open the header
information and the detail information for the order, but not update
the data in the back end until I press a SAVE button.

Are there any examples of forms out there that will do this?
Click to expand...

You would have to use work tables that you temporarily copy the data into
while you work on it and then your [Save] button would run queries to
apply
those changes to the real tables. A lot of extra work IMO to overcome
what
should be a minor training issue for the data entry person.
Click to expand...
 
Back
Top