Posting Or Closing a field

A

administrator

I'm not how to put this so I may get long winded. I have
a table that uses currentdate and bankdate (TBLTickets).
From that I have a TBLTicketsSold, TBLDiscounts, and
TBLCash. On my form FRMTickets, I enter the currentdate,
bankdate, and employeename, then go to the FRMTicketsSold
to enter that information linking the two tables through a
unique number, the same with TBLDiscounts and TBLCash. So
an entry would be.

TBLTickets: IDNumber
EmployeeName
CurrentDate
BankDate

TBLTickets: TBLTickets.IDNumber
Adult
Child
Sr Citizen

TBLDiscounts: TBLTickets.IDNumber
Discount1
Discount2
and so forth.

I currently have my controls on my form for edits,
deletions and additions.

What I would like to have is a "closed" command so that
the user can enter the currentdate and bankdate, go to all
necessary forms, make any additions or deletions, balance
for the day and then close or post so that there cannot be
anymore additions or deletions to that particular combo of
currentdate or bankdate. Or, if necessary, set the
posting date just on bankdate. Is this possible? Thanks
for any help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top