I use MS Access to generate Sales Invoices.
On the sales order form, there are combo boxes for each line item.
You enter an item number or select the item name from drop-down and then an after update even fires. The after update event populates and updates a number of additional fields.
One of the fields the after update event updates is the item cost field.
However, AFTER the order is entered and AFTER the cost field is updated we'll buy the item and there will be a new cost.
I need a way to cycle or loop through a continuous form and run the after update event for every populated combo box.
I can't seem to figure out how to do this.
I need to do the same for check boxes but I'm assuming i'll be able to easily incorporate.
If anyone has the expertise and a min to help me out - I'd greatly appreciate it.
frmSalesOrders
ItemsPanel
Name: cboName
Control Source: InvoiceItemDescription
Check Boxes: ckUnit
Thx so much!!!