Results 1 to 3 of 3
  1. #1
    burrina's Avatar
    burrina is offline VIP
    Windows 7 64bit Access 2002
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383

    Make one field update another field

    I dont know why I am having this problem. On the same form named frm_Employees_on_Call_What_Order

    I have 2 command buttons, one named Thursday and one named Wednesday. I want those buttons to update 2 fields on the same form.
    I have 2 fields also on the same form named OnCallDte and CallNexttDte which are date fields.

    Thursday should update OnCallDte and Wednesday should up date CallNexttDte

    Each of the command buttons Thursday and Wednesday have there own code bound to them in date format.




    Thanks,

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    Please show the vba code related to the controls on the form.

  3. #3
    burrina's Avatar
    burrina is offline VIP
    Windows 7 64bit Access 2002
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    =Format(CDate(Date())-(Weekday(CDate(Date())))-2,"m/d/yy") This is for the command button Thursday and it is a textbox named one
    =Format(CDate(Date())-(Weekday(CDate(Date())))+4,"m/d/yy") "" """ Wednesday "" seven

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

Similar Threads

  1. Replies: 1
    Last Post: 09-05-2012, 02:49 PM
  2. Replies: 5
    Last Post: 06-19-2012, 10:46 AM
  3. Replies: 1
    Last Post: 03-03-2012, 10:17 PM
  4. How do I make a field represent other field names?
    By Alpana in forum Import/Export Data
    Replies: 6
    Last Post: 01-15-2012, 08:41 PM
  5. Make new field based on previous field's answer
    By VictoriaAlbert in forum Access
    Replies: 1
    Last Post: 04-11-2011, 09:54 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