Results 1 to 2 of 2
  1. #1
    Vikki is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Shropshire, UK
    Posts
    19

    Auto Update Forms

    Hi

    Background: Incoming bulk liquids

    Delivery arrives, The Gate House (security) enter

    Vehicle Reg
    Company
    Order Ref
    Temperature

    on their Delivery Log (form)

    The liquid is then sampled and analysed by the lab. The lab Form should show the details the Gate House have entered. The lab then enters their anlalysis results on their Liquid Analysis Log.

    All the data is recorded on one table.

    Problem:

    Is there a way to update the Lab form data to show the Gate House enteries without having to shut and reopen the form. I have tried an update Command with no joy.

    I'm still very green Access.

    Any help apreciated

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Without knowing more we will just have to guess. The GateHouse needs to save before anyone else can see it and others will need to Requery to pick up new records.

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

Similar Threads

  1. Update Query- selective update?
    By stephenaa5 in forum Queries
    Replies: 1
    Last Post: 10-29-2009, 11:15 AM
  2. auto update of two linked tables
    By colenzo in forum Access
    Replies: 4
    Last Post: 07-20-2009, 09:08 AM
  3. Replies: 4
    Last Post: 04-01-2009, 08:49 PM
  4. Replies: 1
    Last Post: 03-08-2009, 01:50 PM
  5. update tables via forms
    By jazoo in forum Forms
    Replies: 0
    Last Post: 09-16-2008, 05:54 AM

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