VB reference to table field

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

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Fields from one table into another 1
JOIN issue: Valid Syntax to refer to (In FROM clause) the Selected Fields from Query 15
Emailing field content 2
Access Command button to look up and copy data from a query to a table 0
Memo field truncated from form to table 4
Add field to Access view of Sharepoint database 1
sub-forms and list choice 2
Referring to another field in the same table 2

Back
Top