show empty textboxes when form (recordsource) is loaded

Question

Hello,

I am creating a Point of Sale in access, on the main form I have 6 textboxes that take values from other controls. These textboxes represent the invoice " total","quantity", "customer name" etc. I am not sure how to proceed in Access, I thought about loading the form with the recordsource pointing to the table where I will store of the invoice details. The problem is that I need, when the form is loaded, to have empty textboxes. Then when the invoice is ready I will use a command button to insert all value in the table and have the textboxes empty to be filled again.

Can do it easily with vba but was wondering if there is a way to do it without code.

Thanks

Answer 1

You can set the 'Data Entry' property of the form to YES and it will open blank on a NEW record.

Answer 2

You are absolutely right, I often feel my brain resist Access, I get continuously stuck but I will get there like I did in the past.  Wouldn't have been possible without all the help I got from you all on this forum!

Thanks

Answer 3

You're on the right track; just be aware that Excel and Access are VERY different beasts. Excel is a spreadsheet, best of breed; Access is NOT - it's a relational database development tool, and requires a lot of very different techniques. Being expert in Excel can be a downright disadvantage sometimes, since you have to not only learn how Access does things, but unlearn some of the Excel "way you always do things".

Good luck and don't hesitate to come here with any questions that come up!

Answer 4

Thank you guys, I have set the "data entry" to yes, exactly what I needed. Thank you Ken for the link, I will take a very good look because it has some of the reports I need.

I am very new to Access but amazed at the possibilities. I had written this POS app in vba Excel but need more features, thanks for your help.

Answer 5

I'm concerned that you refer to a table (singular).  An invoice would normally draw upon at least four related tables, each representing customers, invoices, products, and invoice details respectively, the last modelling the many-to-many relationship type between products and invoices.  You'll find a simple example as InvicePDF.zip in my public databases folder at:

https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169

If you have difficulty opening the link copy its text (NB, not the link location) and paste it into your browser's address bar.

This little demo file is primarily intended to illustrate how to output a report, the invoice, as a PDF file, but it happens to be based on a simple hypothetical invoicing application, whose model is illustrated below.  To enter a new invoice is simply a matter of navigating to a new record in the main invoice form.