Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    42

    Unanswered: Using recordset ! fieldname

    I wish to reference a field that consists of two separate words using the recordset!fieldname format.

    Eg:

    -----------------
    With rstNew
    Do Until rstOld.EOF

    .AddNew

    !Playing Time From = rstOld.Fields("Playing Time From")

    .Update
    rstOld.MoveNext
    Loop
    End With
    -----------------

    The problem is I can't use the fieldname "Playing Time From" because it has spaces and the field is only recognised as !Playing

    Is there some way I can reference this field, given that it has spaces?

    I don't want to have to change all the fieldnames....

    Thanks.

  2. #2
    Join Date
    Apr 2003
    Posts
    42

    Square Brackets

    square brackets fixed the problem...

    ie.

    rstNew![My field Name]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •