Code for a 'Quick Sell' Button

[MamadouNdaw]

The business for which I am designing this database has certain types of transactions that occur many times the same day, and do not require detailed information.

On the main switchboard, I would like to create a button that allows the instant input of a transaction. My table system is rather complicated. This button would have to populate a number of tables, but the only required information is that of the keys and date information.

If not, the user has to manually open the sales window which consists of a form with 2 nested subforms. For certain types of transactions, entering the customer name, additional costs, etc is not relevant or efficient. I simply need the button to insert the date and keys for a particular sale item.

Could this be done with a simple update query initiated by a button?

If anyone has any code that tries to accomplish a similar task it would be much appreciated. I enjoy trying to work through code and see how and where is works.

Thanks guys

 

[Banana]

Wouldn't it be easier to have a separate form for entering new customers, then selecting the customers from a combobox for the sale form? This way, you only need to enter the customers' info *once* and if necessary, merely verify with the customer if their information remains same before making the sale...

 

[MamadouNdaw]

It is actually already set up like that. Basically all sale information is very easy to enter as I use combo boxes. However, it is not feasible to have customer information for every customer. This is a cyber café, so there are many random, non-repeat customers. So, when a number of people come in at the same time, it would be much easier to just have a button that can immediately record each sale.

Granted, it takes about 5 seconds to fill out the sale form as only the date and type of transaction fields are required, but I'd like to add the above functionality.

I'll try to post a small version of the database tomorrow when I have time.

 

[Banana]

Oh, I had same problem. My solution? Created a "Generic" customer record. In the combo box, I made sure that the generic record was something like "<Anonymous>" (with the <> brackets) to ensure that it'd always be the first entry on the combo box.