My code is as follows;
With rstEmployee
!fzcl = (frozen_class)
The fzcl has a space in the recordsource table (fz cl). I don't know how to use a space for it in the VBA code. It gives me the error Item not found in collection.
My code is as follows;
With rstEmployee
!fzcl = (frozen_class)
The fzcl has a space in the recordsource table (fz cl). I don't know how to use a space for it in the VBA code. It gives me the error Item not found in collection.
You shouldn't have spaces, but the work-around is to bracket the field name:
[fz cl]