S
Skip Bisconer
I am updating a table via a form using the table as the data source. I can't
seem to get what I want to work. I have an OrderNo, RouteID and
DeliverySequence field.
The RouteID and DeliverySequence are the fields I need to put data in. They
are blank in the table until they get assigned through the form.
Basic procedure is call up an OrderNo. Assign a RouteID(Text A-Z) and
DeliverySequence (Numeric 1 - many). I have 35 to 40 orders to assign this
information to. I want the RouteID to maintain the value until I change it to
another RouteID. Right now as soon as I update and call the next record the
value is blank for obvious reasons. I am also trying to get the seqence
number to advance by 1 from the previous data update. Any suggestions would
be greatly appreciated.
seem to get what I want to work. I have an OrderNo, RouteID and
DeliverySequence field.
The RouteID and DeliverySequence are the fields I need to put data in. They
are blank in the table until they get assigned through the form.
Basic procedure is call up an OrderNo. Assign a RouteID(Text A-Z) and
DeliverySequence (Numeric 1 - many). I have 35 to 40 orders to assign this
information to. I want the RouteID to maintain the value until I change it to
another RouteID. Right now as soon as I update and call the next record the
value is blank for obvious reasons. I am also trying to get the seqence
number to advance by 1 from the previous data update. Any suggestions would
be greatly appreciated.