using macros with checkboxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 !!!
 
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.
 
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.
 
The checkbox control on your form must be bound to the field that stores the
"in / out" condition.
 
Back
Top