Set current field in Form recordset

[Dave]

I have a form (Form1) that display multiple rows from a
query. For each row on Form1 a button exists that the
user can click on it pops up another small form (Form2)
where the user can enter notes for the specific record
from Form1.

I have this working well, but I'd like to have it so that
when the user enter notes on Form2 and then closes the
Form2 window, it updates a checkbox (to true) on Form1
indicating that the row has notes. I know that I need to
do this using the recordset from Form1, I'm just not sure
how to access the current row of Form1 and then set the
checkbox field for that record.

Any help is appreciated.

Thanks Dave

 

[Tim Ferguson]

I have this working well, but I'd like to have it so that
when the user enter notes on Form2 and then closes the
Form2 window, it updates a checkbox (to true) on Form1
indicating that the row has notes.

As long as you can ensure that the user has not moved the current record on
Form 1 (i.e. Form 2 was opened in Dialog mode), then you can simply update
the control on Form 1 directly:

Forms!FormOne.chkCheckValue = True

DoCmd.Close acForm, Me.Name



Hope that helps


Tim F