Update a table field by checking a checkbox

[millers92]

Ok...I think I have successfully confused myself. I have a main form (Forecast) that has a subform (forecastsub) that displays the contents of a table (forecasttbl) in a queried format. I did not link the forms as I want to see all the records that meet my query parameters and let the users have the ability to enter data.

I have two questions:

1) Currently I have a check box (Check31) on the subform (forecastsub) and would like to be able to check and uncheck individual records without it checking all the records on the subform.

2) When this check box is checked, I would like it to update a field(bc paperwork time) in a table(forecasttbl) with the current date and time.

I'm sure that these are very easy things to do, but I just can't seem to get my brain around them...

Any help would be greatly appreciated!

Thanks!

Steve

 

[Pat Hartman]

An unbound checkbox can have only a single value. That's why when you change it on one subform record, it changes on all. Show the date field and use its double-click event. Or, use the double-click event of some other field if you don't have room to show the date field.