Thank you for replying.
My user interface consists of a form which is created from a query on the customer table and sales order table. There is a subform attached which comes from a query on sales order line items and stock. The user is able to select a stock item and enter a quantity...
I have created a sales order form which pulls information from a inventory table. With each stock item entered on the sales order I have created a command button that subtracts the quantity ordered from the qty on hand in the inventory table.
My problem is that I want to keep the user from...
I have created a calculated control in a form which gives me the total of items purchased. How do I send the total to the underlying table to be saved?
I have a form with several combo boxes and would like to be able to add a record to the underlying table when the selection I want is not in the list. Does anyone have an idea on how to write the code behind the NotInList Event?
I have a combo box in a form which is linked to a table in my database. I want to be able to add a record to the combo box (table) if it is not in the list. Does anyone have the code to add a record on NotInList event?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.