Need Help With Form -- Input Box and more

[bgannon]

Background:
I am trying to make an access database "app" that will replace a tally sheet/tab system we run at work at a gun range. We check people in and issue them give them a 3 digit tag we grab from a box. We write this tag number down and run a tab system (like at a bar for drinks) for all items they are purchasing (range fees, ammo, paper targets, gun services etc.). I want to replace this with an access "app" that opens to a menu that prompts a user to enter a new tag, view and existing tag, edit and existing tag (add more items), or close a tag (run a query for all items on the tag and calculate a total).

I am stuck in the beginning where I have a button called "New Tag" that i want to pop up an input box and have the person enter the new tag number, this number will be stored into the "Open Tags" table under the field "tag_number"

then the user can navigate to the "Fees" form and add fees (via buttons) to that tag then to subsequent forms (Targets, Ammo, Services) or back to the main menu to edit an open tag to add or subtract items.

I am still very novice in Access and self teaching, i have a small background in coding java several years ago so i understand objects and how code works just not VBA or SQL.

MY QUESTION:
what code or macro do I use, when a user clicks the "new tag" button on the main menu to pop up a input box and have them enter the tag number and save it or cancel back to the main menu.

an alternative is to have a static text box on the main menu that they type in the tag number then click "new tag"


PLEASE HELP AND GRANT ME YOUR WISDOM ACCESS GODS

 

[Ranman256]

ID use the form. The form would be hooked to tInvoice table. You are making an invoice just like a shopping cart on every web store.

Enter the tag# in a text box. It also has a box of current date/time. Customer if needed.
Tag#,invoiceID,InvDate,customer,PdAmt

Below the text box is a continuous form of items to add. The tInvoiceDetail table.
Add other items,
Targets,qty,
Ammo,qty,
Service,qty.

A table of tPriceList that holds the prices,
Ammo, $20.00
Target,$0.50

When you enter item in the tInvoiceDetail, (combo box)
It fills in the price,the Ext price =Price*Qty.
The form footer,adds it all up. =sum(ExtPrice)
A report will print as invoice/receipt.

A query would calc ExtPrice,
Item,price,Qty,ExtPrice

 

[bgannon]

my problem with a text box is how does it know to add the text to the proper field.

i.e. a text box next to 3 buttons (add tag, view/edit tag, close tag) so the user enters "543" into the text box, how does access know to create a new record in the open tags table under the field "tag_number"?