using macros with checkboxes

[Gemma]

Hi
I'm trying to set up a video database. i have a number of copies of each
video that i want to hire out. i want to keep track of them via a status
available checkbox. when i hire out the video copy in the hire form i want
the status checkbox to be ticked. i cannot figure out how to do this via a
macro. can anyone help me please !!!

 

[Ken Snell [MVP]]

SetValue will set the value of a control. For a checkbox, True or False are
the values (checked or unchecked, respectively).

But, I'm not sure that this is what you really need here? If you store the
value (hired out ; not hired out) in a field in a table, then you'll have
that info already available.

Perhaps you can tell us more details about what you're wanting to do here.

 

[Gemma]

Hi Ken
Thanks for your response. I have a table called Video and a table called
Item. To uniquely identify each title copy you have to know the Video_ID and
the Copy_ID. In the item table there is a field showing availability that is
called currently hired (Checkbox). It is only supposed to be checked when the
copy is out on loan. When I go to my hire form (based on a new table and
linked to the Item and Video table via the keys Copy_ID and Video_ID) and try
to hire out the copy I want to run a macro that will automatically check it
out of the Item table. I have used the set value property action and entered
my where condition. When I run the Macro with the step it looks like it is
running correctly only it never updates the table.

 

[Ken Snell [MVP]]

The checkbox control on your form must be bound to the field that stores the
"in / out" condition.

 

[forti123]

All,

I'm trying to set up a homepage .Can you help me?

FOrti123