A
art
I am trying to use SetValue to force a value to a form from a query
that is automatically run (using a macro that is launched on the
OpenEvent of the form).
The value is determined from a query that creates a new number (like
an AutoNumber) by finding the highest value in the table (using DMAX)
then adding 1 to the number. I want this value to then be forced to
the form to create a new record.
Unfortunately, when the form is opened, the query is launched by the
macro however, the macro is halted and a dialog box appears stating
"you can't assign a value to this object". The highest value from the
query is shown in the background.
I have not been able to correct this problem and would like some
advice how to proceed. Any ideas?
Thank you.
that is automatically run (using a macro that is launched on the
OpenEvent of the form).
The value is determined from a query that creates a new number (like
an AutoNumber) by finding the highest value in the table (using DMAX)
then adding 1 to the number. I want this value to then be forced to
the form to create a new record.
Unfortunately, when the form is opened, the query is launched by the
macro however, the macro is halted and a dialog box appears stating
"you can't assign a value to this object". The highest value from the
query is shown in the background.
I have not been able to correct this problem and would like some
advice how to proceed. Any ideas?
Thank you.