Results 1 to 2 of 2
  1. #1
    spacemonkey79 is offline Novice
    Windows XP Access 2003
    Join Date
    Oct 2010
    Posts
    1

    Update Field.


    Hi Guys,

    I'm new at designing acess. I'm tryng to write a VB code that will update a text field with the word 'OLD' By default I want it to say 'NEW' Upon clicking the button, I want it to say OLD

    my button is called 'Next Record' and my text field is caled 'Source'

    Example. When user first open this up the text field (source) will say 'NEW'
    After clicking the (Next Rcord) button it will change to 'OLD'

    Thanks in advance.

  2. #2
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    Just put me.source="OLD" in the begging of the click event.
    Code:
    private sub next_record_click()
           me.source="OLD"
    end sub

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Update field in subform from field in Main
    By jpkeller55 in forum Access
    Replies: 9
    Last Post: 10-15-2010, 03:37 PM
  2. Update field in table after update on a subform
    By jpkeller55 in forum Queries
    Replies: 3
    Last Post: 09-30-2010, 08:02 PM
  3. Replies: 2
    Last Post: 05-05-2010, 02:52 PM
  4. last update in field deffualt value
    By miziri in forum Programming
    Replies: 3
    Last Post: 08-13-2009, 11:06 AM
  5. how to update only one field in 1 table?
    By viccop in forum Access
    Replies: 3
    Last Post: 02-21-2009, 02:32 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums