I feel like this should be easy, but after 6 hours of web
search, online help, and books, I am still stuck. I hope
someone can help.

I have 3 tables in a query whose results are used to
display my first form - parameter Cashier Number.

Tables:
Cashier - Their Name, CashierNumber, OffRegister (No or
Yes indicating removal for poor performance), DateOff
Register
Employee - File# (which is link to Cashier Number),
HomeLocation
OverShort - CashierNumber, SaleDate, StoreNumber,
OverShort$, Ignore (No or Yes, indicating the record,
received from our outside source, is wrong and a
replacement has been created [what I'm trying to do]) and
VarType (I, M or D). Key to table: CashierNumber,
SaleDate, StoreNumber and Ignore

My form is fine to bring up the OverShort records based on
the search. I have a button "Update this Record" that,
when clicked, brings the data from that record to another
form that will (should) allow the user to update
OverShort$, Ignore and VarType. Since I don't want to
ever lose the original record, I want to first change
Ignore to YES (from default NO), so I can Append a record
with the same Key info, and the corrected OverShort $
amount.

I click "Update this record" and open a new form. I get
all the data from the first form (Source is Form!
F_CashierOS!FieldName), and I want to be able to update
the 3 fields, but I can't.

I first want the user to be able to click "Ignore this
Record" button that runs a query simply to change Ignore
NO to YES. This works when I run the query and manually
enter the fields (the form names pop up as parameters),
but won't work when I try to run it from the button.

I just want to change Ignore to YES, so we can then put in
the NEW record with the proper data, but NEVER delete what
we got from the vendor.

Once Ignore is YES, the user can change the $ amount and
Ignore (and type), and add a new record - with an Append
Query.

I am not sure the Update form is right; I run the initial
query and get 202 records. I go to the "Update this
record": form and I get 56,813 records - but They are all
the same record!

I can get the data from the first form to show on the
second, but it can't be updated.

I've tried all that I can find - DataEntry, Updatable,
with Inconsistencies, - but nothing has worked.

Any and All help is appreciated. I have a class at the
end of the month, but I'm not positive they'll cover these
topics. I think it's more VBA.