Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2005
    Posts
    61

    Unanswered: How do I enter a value in current record?

    Hello,

    I am creating a record and entering data into fields that are linked to fields within the table then saving them. These work fine. But I have a field that is unbound and when I save the record I want the unbound field value be put into the name field on the table.

    how can I save the name value to the current record that I just saved?

    Thank you.

    Mythos

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    Why not just bind the Form's Name field to the Table Name field like you've done with all the other fields?

    If your record is already saved then you could use the SQL UPDATE statement in conjunction with CurrentDB.Execute.

    For example:

    Code:
    CurrentDB.Execute "UPDATE yourTableName SET theTableNameFieldName = '" & Me.myFormNameFieldName & "' WHERE myTablesRecordIDFieldName=" & theRecordIDFieldNameOnForm
    .
    Environment:
    Self Taught In ALL Environments.....And It Shows!


Posting Permissions

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