Results 1 to 2 of 2
  1. #1
    srdjanrsub is offline Novice
    Windows 10 Access 2003
    Join Date
    May 2020
    Posts
    1

    Change function value in guery


    Greeting
    How to when i click in Form1 on first button, then to change data in query2 in
    in: IIf([event_point_id]=1,3,5;[time];Null) and out: IIf([event_point_id]=2,4,6;[time];Null)
    *data is bold
    same is for second and third button
    how to do it this?
    Attached Files Attached Files

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870

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

Similar Threads

  1. Function to Change Color of Combo
    By SteveApa in forum Forms
    Replies: 10
    Last Post: 02-08-2018, 11:33 AM
  2. Replies: 2
    Last Post: 04-28-2017, 10:21 AM
  3. Replies: 1
    Last Post: 11-30-2012, 05:57 AM
  4. Need a function to change queried text
    By rjohnson in forum Queries
    Replies: 2
    Last Post: 02-20-2012, 10:28 AM
  5. Using function to track change through months
    By Accessuser in forum Programming
    Replies: 8
    Last Post: 09-28-2010, 04:09 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