Combo Box After Update Programming Question

[Kaloyanides]

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!!!

[CJ_London]

use an update query rather than cycling through the form - use the form recordsource and filter/link to create the basic query

not enough information to be any more specific

[orange]

Further to Ajax's comments, it would be helpful if you could show us your tables and relationships to help with context. A demo copy of your database would also be useful to responders.