Check Box - Update a Table

  • Thread starter Thread starter Roy
  • Start date Start date
R

Roy

I would to update a field in a table to todays date by
using a check box in a form it also needs to reset itself
to being unchecked.

Scenario: I send a tape out for loan and when it is
returned I wish to tick a box (so to speak) with the
returned date (being that day of return).
 
Roy said:
I would to update a field in a table to todays date by
using a check box in a form it also needs to reset itself
to being unchecked.

Scenario: I send a tape out for loan and when it is
returned I wish to tick a box (so to speak) with the
returned date (being that day of return).
Click to expand...

I'm not sure what's the point of a check box that immediately unchecks
itself after you check it. Why not just use a command button, or even a
label, that when clicked inserts the current date in the DateReturned
field?
 
-----Original Message-----


I'm not sure what's the point of a check box that immediately unchecks
itself after you check it. Why not just use a command button, or even a
label, that when clicked inserts the current date in the DateReturned
field?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


The check box will allow me to update multiple tapes at
Click to expand...
once since they are sorted on date order. Will a label
or a command button do this on multiple tapes
 
The check box will allow me to update multiple tapes at
once since they are sorted on date order. Will a label
or a command button do this on multiple tapes
Click to expand...

You'd need to use code for it, but I don't see how a check box will let
you do that any better than a button or label would. I must not be
picturing this the same way you are. I think you'd better describe how
you see this working. What do you expect to see on your form, and how
do you hope to interact with it?
 
Back
Top