Checkbox question

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

Guest

I have a form that is used to "check out" an item (for rental). Each item is
stored by its unique serial number in a "products" table. There is then a
"status" checkbox in each record of the products table to show if the item is
checked out.

What I am looking to do is use the form I've created for "checking out" by
adding a checkbox to the checkout form that will read the serial number in
the checkout form, and update the status in the products table as being
checked out.
 
I have a form that is used to "check out" an item (for rental). Each
item is stored by its unique serial number in a "products" table.
There is then a "status" checkbox in each record of the products table
to show if the item is checked out.

What I am looking to do is use the form I've created for "checking
out" by adding a checkbox to the checkout form that will read the
serial number in the checkout form, and update the status in the
products table as being checked out.
Click to expand...

Hi Jimmy,

You are probably using a ComboBox to select the serial number from the
"products" table. Why not use the AfterUpdate event of the ComboBox to
mark the item as "checked out"?

hth
 
RuralGuy said:
Hi Jimmy,

You are probably using a ComboBox to select the serial number from the
"products" table. Why not use the AfterUpdate event of the ComboBox to
mark the item as "checked out"?

hth
Click to expand...

Thanks,
Any idea on what the code would look like for that? The table that the
status is on is not linked to the "check out" form. It is a seperate form.
I tried
[table.field].selected = true 'status is a yes/no field
but I get the "could not find "|" field referred to in your expression" error
 
Thanks,
Any idea on what the code would look like for that? The table that
the
status is on is not linked to the "check out" form. It is a seperate
form. I tried
[table.field].selected = true 'status is a yes/no field
but I get the "could not find "|" field referred to in your
expression" error
Click to expand...

Hi Jimmy,

It would be very helpful if you could post the actual Row Source
(in SQL format) for the ComboBox?
 
Back
Top