Hi All,
I have the follwing query which is executed following the update of a
combo box within a subform. When the subform is open in it's own window, it
works fine, however, when I have the master form open and update the combo
box, the query promps for [forms]![qry_trailer_status]![bookref] &
[forms]![qry_trailer_status]![key].
I'm guessing that this is due to refering to a field within the subform and
not the master form but I do not know how to work around this?
UPDATE tbl_trailers INNER JOIN iinord ON tbl_trailers.key = iinord.key SET
tbl_trailers.bay = forms!frm_trailers!bay
WHERE (((iinord.arr)=-1) AND
((tbl_trailers.bookref)=[forms]![qry_trailer_status]![bookref]) AND
((iinord.key)<>[forms]![qry_trailer_status]![key]));
Any help would be much appreciated,
Mark