Results 1 to 4 of 4
  1. #1
    mwhcrew is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    4

    Deleting values after a field is updated

    I have a form with fields on it for Location and DateShipped. Location is currently a combobox. I would like to make it so that when a value is entered into the DateShipped field, the value in the Location field gets erased back to null. Is this possible? Thanks!

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    i think u just have to use
    Code:
    me.combobox null 

  3. #3
    mwhcrew is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    4
    oh man i'm an idiot, I had tried that but had used the field name instead of the combobox name. thanks so much!

  4. #4
    rohnds is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2010
    Location
    Austin, TX
    Posts
    7
    Me.combobox=""

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

Similar Threads

  1. Force form not to save updated fields
    By Evgeny in forum Programming
    Replies: 2
    Last Post: 04-30-2010, 10:44 PM
  2. the last updated date and time
    By venu in forum Access
    Replies: 2
    Last Post: 04-02-2010, 08:11 AM
  3. Replies: 0
    Last Post: 09-01-2009, 12:33 PM
  4. return last updated date for each product
    By jonnyuk3 in forum Queries
    Replies: 0
    Last Post: 06-17-2009, 04:38 AM
  5. macro to updated tables
    By Wrangler in forum Import/Export Data
    Replies: 1
    Last Post: 01-18-2006, 11:01 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