Multiple IFs in VBA - Help writing code please

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lori - 27 May 2008 22:21 GMT

Okay, hopefully this is simple. I am using two pictures on a form that fill
a void when a subform is empty. I have the properties set to visible=no and
an event set up "on activate": If me.otherexpenses=0 then
me.other-excel.visible=true. This works beautifully, however, I have two
pictures. I've tried to set the code in "on open" but I get an error stating
that there is no value in the "otherexpenses" field.

How would write the code so that it will look at the "otherexpenses" and
"businesstotal"?

All help is definitely appreciated.

Signature

Lori A. Pong

Reply to this Message

Duane Hookom - 27 May 2008 22:32 GMT

Since this is a Report news group, I would suggest you add code to the On
Format event of the section containing the images and the bound controls.
"OtherExpenses" must be bound to a control in the section in order for the
code to work.

Signature

Duane Hookom
Microsoft Access MVP

> Okay, hopefully this is simple. I am using two pictures on a form that fill
> a void when a subform is empty. I have the properties set to visible=no and
[quoted text clipped - 7 lines]
>
> All help is definitely appreciated.

Reply to this Message

Lori - 28 May 2008 16:03 GMT

that's the strange part. Either one will work fine in the "on activate"
event. So the format for both the otherexpenses and the businesstotal. My
question is how can I write this "on activate" so that it will basically do
this:

If me.otherexpenses = 0 then
me.other-excel.visible = true
AND
If me.businesstotal = 0 then
me.bus-excel.visible = true

Signature

Lori A. Pong

> Since this is a Report news group, I would suggest you add code to the On
> Format event of the section containing the images and the bound controls.
[quoted text clipped - 12 lines]
> >
> > All help is definitely appreciated.

Reply to this Message