Recent content by kramsey

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?