VB reference to table field

M

Mark1

I've got this code, but I need to figure out the syntax for the !COMMENT
part. I want it to refer to the master table's COMMENT field. This code,
however is in the main form. I've tried [Tables]!Table1.Comment among
others, but it gives an error. Any help? Thanks!!!

With Me.RecordsetClone
.AddNew
!Name = Me.Name
!DOB = Me.DOB
!COMMENT =
.Update
 
L

Larry Linson

Mark1 said:
I've got this code, but I need to figure out the syntax for the !COMMENT
part. I want it to refer to the master table's COMMENT field. This code,
however is in the main form. I've tried [Tables]!Table1.Comment among
others, but it gives an error. Any help? Thanks!!!

With Me.RecordsetClone
.AddNew
!Name = Me.Name
!DOB = Me.DOB
!COMMENT =
.Update
Click to expand...

What is the exact error and, did it occur on the line
!COMMENT =
Click to expand...

And, is the Comment Field included in the Form's Record Source? You are
doing this in a Form, aren't you, not a Report?

Larry Linson
Microsoft Access MVP
 
Top