trouble with drop down based on other drop down

[DBritter]

The problem is that a message box appears asking for criteria of [lngShipping]. This box appears as the subform is opened and when the [lngShipping] is changed.


I have a list box[lngShipping] that is based on another list box[lngShippingOption]. On update of the of the first list box[lngShipping] there is a requery event that makes all of the records in [lngShippingOption] relate to [lngShipping].

The query is as follows:

SELECT tlkpShippingOption.lngShippingOptionID, tlkpShippingOption.strShippingOption, tlkpShippingOption.lngShippingID FROM tlkpShippingCompany INNER JOIN tlkpShippingOption ON tlkpShippingCompany.lngShippingID = tlkpShippingOption.lngShippingID WHERE (((tlkpShippingOption.lngShippingID)=[forms]![frmNewOrderExistingCustomer]![fsubNewOrderExistingCustomer]![lngShipping]));