Well just to introduce my project I've been working on. My church is opening up a bookstore and was going to use an excel spreadsheet to keep track of the books and music. So I threw together a database in access and though the forms were the best way to emulate a Point of Sale system. I have a functioning POS system but I've hit a brick wall.
My Main question is, is there any way to pull the current data from a text box into a function? For example In my database I have a purchase button and right now the person has to enter the book ID that is on the screen to actually purchase it. This would be much more user friendly if there was a way for access to know what was on the screen but I'm thinking it might not be possible.
There are a few other little things, such as if you click cancel or enter a wrong value for the macro it gives you an access error instead of a nicer looking error explaining what's wrong. Or after you select a record in the combobox it highlights the title you selected and I would just like it better if it deselected the record after you clicked it. But that is just cosmetics. I plan on adding records and reorder forums once everything is more concrete.
Thanks for taking the time to read this and any pointers and/or tweaks would be appreciated.
EDIT: I attached the zip file to the thread.