P
Peter
I have a dlookup which retrieves values from a query. The query stops
working when the after update event fires. The query works fine at other
times. They query uses a [Forms]![frm_abc]![field] reference in the where
clause and this does not seem to resolve when the event is processing. for
example if I type the value for the field into the query, it retrieves values
but if I let the query try to resolve the [Forms] resolution it doesn't work.
It retrieves no values. In the form after update code I can do a msgbox and
it resolves the [Forms] thing but not in the query.
working when the after update event fires. The query works fine at other
times. They query uses a [Forms]![frm_abc]![field] reference in the where
clause and this does not seem to resolve when the event is processing. for
example if I type the value for the field into the query, it retrieves values
but if I let the query try to resolve the [Forms] resolution it doesn't work.
It retrieves no values. In the form after update code I can do a msgbox and
it resolves the [Forms] thing but not in the query.