Still need help with update records

[nalbiso]

Hello,

I still need some help with a problem that I am having. I want to update a field on a form called Completed_by with the contents of a field called txtcurlogin when a check box called checksubfilled is checked. (The value of the check box is "Yes" when it is checked if that makes any difference.

How would I do this?

I appreciate any assistance [sig][/sig]

 

[MichaelRed]

In the onchange event of the checkbox:

IF (Me.checksubfield) then
[tab]Me.Completed_By = Me.txtcurlogin
End If [sig]<p>MichaelRed<br><a href=mailto:mred@duvallgroup.com>mred@duvallgroup.com</a><br>There is never time to do it right but there is always time to do it over[/sig]

 

[Robertd]

Hi nalbiso,

i take it checksubfilled and me.txtcurlogin are on the same form and yourformname will be open??

something like

sub checksubfilled_onClick()
' maybe check if yourformname is loaded
if me.checksubfilled then
' maybe check isn't Null
Forms![yourformname]![Completed_by] = me.txtcurlogin
end if
end sub

HTH [sig]<p>Robert Dwyer<br><a href=mailto:rdwyer@orion-online.com.au>rdwyer@orion-online.com.au</a><br>[/sig]

 

[nalbiso]

Thank you both! I kept writing the same error over and over again.

I appreciate the assistance!

[sig][/sig]