SetValue Macro

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
 
S

Steve Schapel

Christine,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top