Update Check Numbers

[burrina]

I have a situation where sometimes the check numbers printed do not match the check numbers in the database since the check numbers are generated thru the database.
So I need to edit those check numbers to match. I need to use a form for this and allow the user in charge to change the check numbers the match what has been printed.

Table name of where checks are stored is TCheckNo
Field name to change is ChkNo and is number format
FK in table is EmployeeID

tblEmployees
EmployeeID PK

Tables are linked.

[burrina]

Hmm, the light just came on and now somebody is home. Solution is to add a form bound to the payee and a subform that shows all the records, then they can easily change them.

Sometimes the light is on and nobody is home, sometimes the light is home and yes I'm there.

Thanks Everybody on here for the support. Hope all of your projects are going well.