Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2008
    Posts
    5

    How to make an autorefreshing?


    Hi to all,

    i have a main form wich is an overview and has a sub form related to a querry composed with some fields of the AGENT table and PROBLEM table. Each one of these tables has its related form: AGENT_FORM and PROBLEM_FORM.

    Actually the previous datas are refreshing every time Icreate a new data entry.
    I would like that my overview form is refreshed with every entry of single data in the AGENT_FORM and PROBLEM_FORM.

    I've heard about Me.Recalc or Me.query but i'm brand new in access programming and I don't really now where and how to use it. I most use the expressions already proposed by Access, and I have avoided VBE programming... until now.

    Thanks for any help.

  2. #2
    Join Date
    Oct 2007
    Posts
    10

    Please reply.

    Oki dok. This is kind of hard to explain without you telling me which field you would like to refresh, so what is the name of the field you would like to refresh? When would you like it to be refreshed?

  3. #3
    Join Date
    Feb 2008
    Posts
    5
    Thanks for the help I will try to be clear.

    Here are my tables with their related fields:

    PROBLEMS_Table:
    Pb_ID / Status / Client Nr / Date / raison of status / Problem / Problem description / Land.
    (linked 1 to many with the AGENT_table, using Pb_ID)
    cause for 1 problem we can have many actions (interventions) from different agents

    ACTION_Table:
    Aktion_ID / Pb_id / Aktion / Date / Agent

    ----------------------------------------------------------------------------------------

    here are my forms with their related fields:

    SUPERVISOR_OVERVIEW FORM
    Subform(Status, raison of status, Problem, Client Nr, Date, Agent, Problem) it's conected to a query composed with the field of the PROBLEM_Table and the "Agent" field of the ACTION_Table

    AGENT FORM
    Status, Client Nr, Date, Raison of Status, Problem, Problem description, Land.
    Subform(Aktion, date, Agent)


    i would like an interactivity between both forms:
    I would like that the supervisor visualizes at the same moment, on the SUPERVISOR_FORM the changement made by the agents on the AGENT FORM, and that the agents are abble to see the changements of the supervisor made on the fields "Status" and "Raison of status" from the SUPERVISOR_FORM

    Pfiuu! hope that's helping
    thanks a lot once again

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

Similar Threads

  1. Replies: 1
    Last Post: 10-28-2008, 08:38 AM
  2. Adding new column to make-table query
    By dtn118 in forum Access
    Replies: 2
    Last Post: 08-03-2008, 06:51 AM
  3. Make a booking availibility checker - please see pseudocode!
    By sirantonycartwright in forum Programming
    Replies: 0
    Last Post: 09-03-2007, 10:07 AM
  4. Make entries uneditable based on checkbox
    By acehowell in forum Programming
    Replies: 1
    Last Post: 04-19-2007, 07:54 AM
  5. Replies: 2
    Last Post: 09-01-2006, 04:03 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