how 2 create check box upon check it copiy A to B, upon uncheck i.

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

Guest

MS ACCESS - how to create a check box that upon checked it will copy date
from from column A to column B and upon unchecked it will delete data in
column B. Both A and B are in the same ms access table.
 
You might be able to use code in the After Update event of your check box
control like:
If Me.chkYourCB = True Then
Me.txtColumnB = Me.txtColumnA
Else
Me.txtColumnB = Null
End If
 
can u xplain what's
you might be able to use code in the After Update event of your check box
control like:
If Me.chkYourCB = True Then
Me.txtColumnB = Me.txtColumnA
Else
Me.txtColumnB = Null
End If
if it is possible can u give me sample table with such functions / codes
already installed. so that I can learn further.

Tq
 
I don't think this is the place to offer a tutorial on event code. The code
I provided was in a form's module and I don't know if I can be much more
explicit. Consider finding a decent book on Access that provides an
introduction into VBA. John has some recommendations on his web site
www.viescas.com.

Please don't reply in this news group. If you need more assistance, please
begin a new thread in the microsoft.public.access.modulescoding news group.
 
Back
Top