Switchboard button +1

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a switchboard button that is "Add Receipt". When I select this from
the switchboard, i would like to the form to come up with the last
"ReceiptNum" +1.
The table is tblReceipt, which consists of ReceiptID (PK, Autonumber),
ReceiptNum (Text Field), etc. The ReceiptNum is RE060001, RE060002, etc.
When the "Add Receipt button is selected, I would like the ReceiptID to
automatically insert the last ReceiptNum + 1.
 
Sharon said:
I have a switchboard button that is "Add Receipt". When I select this from
the switchboard, i would like to the form to come up with the last
"ReceiptNum" +1.
The table is tblReceipt, which consists of ReceiptID (PK, Autonumber),
ReceiptNum (Text Field), etc. The ReceiptNum is RE060001, RE060002, etc.
When the "Add Receipt button is selected, I would like the ReceiptID to
automatically insert the last ReceiptNum + 1.
Click to expand...

If you don't store thr "RE" in the table and make the rest a numeric field,
you can use Max to find the highest number in the table and then add one.

Tom Lake
 

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

Similar Threads

Command Button Add Code 6
Command Button - Add New Record +1 2
Access Switchboard error message 1
Access 2007 Switchboard buttons stop working 3
how to log switchboard button clicks 2
Switchboard button problem 2
Exporting to Excel from Switchboard (Switchboard Manager) 1
Switchboard Wizard Number of Items on Page 7

Back
Top