SetValue Macro

  • Thread starter Thread starter Takayla
  • Start date Start date
T

Takayla

I've tried just about everything I can think of, even reverting to microsoft
help and access bible, but still can't figure out what I'm doing wrong.

First, I'm still using Access97 for this project. I have a form that has a
drop down list of bill #s. When the user picks one then hits ok, it should
start a macro that prints the bill (that works) then start the setvalue macro
to set a checkbox to yes on another form showing that the invoice has been
printed. This info also gets stored as a value in the original table.

My setvalue looks like this:
Item: [Forms].[BillLading]![Printed]
Expression: Yes
BillLading is the form name, Printed is the name of the checkbox.

The error that I get is "An error occurred while referencing the object. You
tried to run a visual basic prodcedure that improperly references a property
or method of an object."

Does anyone know what I'm doing wrong?

Thanks,
Christine
 
Christine,

Try using a ! rather than a . in the Item argument...
[Forms]![BillLading]![Printed]
 
Back
Top