Results 1 to 9 of 9
  1. #1
    qbc is offline Advanced Beginner
    Windows 2K Access 2003
    Join Date
    Aug 2009
    Posts
    30

    Database Updated but Form doesn't Show data

    ok, I have another problem I really need help with.
    I just noticed that the two forms I have created are updating the main table but once you get out of the form and go back in, that record is not shown or pulled by the query.
    I looked in the table and the records are there.



    Anybody have any thoughts?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Perhaps the Data Entry property of the form is True or it's being opened in that mode.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    qbc is offline Advanced Beginner
    Windows 2K Access 2003
    Join Date
    Aug 2009
    Posts
    30
    I am not sure about that because if I just run the query alone, those records still don't show up.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    What's the SQL of the query?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    qbc is offline Advanced Beginner
    Windows 2K Access 2003
    Join Date
    Aug 2009
    Posts
    30
    SELECT [PPAC Main].[TAM Code], [PPAC Main].[SIC Code], [PPAC Main].[Policy Status], [PPAC Main].Reason, [PPAC Main].[Business Type], [PPAC Main].[Underwriting Office], [PPAC Main].Underwriter, [PPAC Main].Brokerage, [PPAC Main].[Named Insured], [PPAC Main].[Mailing Address], [PPAC Main].[Unit/Suite/Apt #], [PPAC Main].City, [PPAC Main].Province, [PPAC Main].[Postal Code], [PPAC Main].[Policy #], [PPAC Main].[Effective Date], [PPAC Main].[Expiry Date], [PPAC Main].[Property Premium $], [PPAC Main].[CGL Premium $], [PPAC Main].[Crime Premium $], [PPAC Main].[B&M Premium $], [PPAC Main]![Property Premium $]+[PPAC Main]![CGL Premium $]+[PPAC Main]![Crime Premium $]+[PPAC Main]![B&M Premium $] AS [Total Policy Premium], [PPAC Main].[Broker Commission], [PPAC Main].[Premium Financing?], [PPAC Main].[Earthquake Deductible %], [PPAC Main].[Property Deductible], [PPAC Main].[Sewer Back-Up Deductible], [PPAC Main].[Water Damage Deductible], [PPAC Main].[Flood Deductible], [PPAC Main].[Crime Deductible], [PPAC Main].[CGL/NOA/EB/Personal & Advertising Injury/Prod Ops Limit], [PPAC Main].[TLL Limit], [PPAC Main].[FFE Limit], [PPAC Main].[Employers Liability Limit], [PPAC Main].[S&A Pollution Limit], [PPAC Main].[TLL/FFE/Employers/S&A Deductible], [PPAC Main].[# of Employees], [PPAC Main].[Operations Outside Canada?], [PPAC Main].[Fees (CAD)], [PPAC Main].[Fees (USD)], [PPAC Main].[Fees (FOREIGN)], [PPAC Main].[Crime Package Limit], [PPAC Main].[Up Sell Limits & Coverage], [PPAC Main].[E&O with JLT?], [PPAC Main].Endorsements, [PPAC Main].[5 Years Claims], [PPAC Main].[Claims Carrier], [PPAC Main].Notes, [PPAC Main].[Location #], Locations.[Location 1], Locations.[Cresta Zone 1], Locations.[Construction 1], Locations.[Age of Building 1], Locations.[Sq Ft 1], Locations.[Sprinklered 1], Locations.[Burglar Alarm 1], Locations.[Fire Alarm 1], Locations.[Protection 1], Locations.[Building Limit 1], Locations.[Business Property Limit 1], Locations.[Laptops 1], Locations.[Field Equipment 1], Locations.[Business Income Limit 1], Locations.[Accounts Receivable 1], Locations.[Valuable Papers 1], Locations.[Location 2], Locations.[Cresta Zone 2], Locations.[Construction 2], Locations.[Age of Building 2], Locations.[Sq Ft 2], Locations.[Sprinklered 2], Locations.[Burglar Alarm 2], Locations.[Fire Alarm 2], Locations.[Protection 2], Locations.[Building Limit 2], Locations.[Business Property Limit 2], Locations.[Laptops 2], Locations.[Field Equipment 2], Locations.[Business Income Limit 2], Locations.[Accounts Receivable 2], Locations.[Valuable Papers 2], Locations.[Location 3], Locations.[Cresta Zone 3], Locations.[Construction 3], Locations.[Age of Building 3], Locations.[Sq Ft 3], Locations.[Sprinklered 3], Locations.[Burglar Alarm 3], Locations.[Fire Alarm 3], Locations.[Protection 3], Locations.[Building Limit 3], Locations.[Business Property Limit 3], Locations.[Laptops 3], Locations.[Field Equipment 3], Locations.[Business Income Limit 3], Locations.[Accounts Receivable 3], Locations.[Valuable Papers 3], Locations.[Location 4], Locations.[Cresta Zone 4], Locations.[Construction 4], Locations.[Age of Building 4], Locations.[Sq Ft 4], Locations.[Sprinklered 4], Locations.[Burglar Alarm 4], Locations.[Fire Alarm 4], Locations.[Protection 4], Locations.[Building Limit 4], Locations.[Business Property Limit 4], Locations.[Laptops 4], Locations.[Field Equipment 4], Locations.[Business Income Limit 4], Locations.[Accounts Receivable 4], Locations.[Valuable Papers 4], Locations.[Location 5], Locations.[Cresta Zone 5], Locations.[Construction 5], Locations.[Age of Building 5], Locations.[Sq Ft 5], Locations.[Sprinklered 5], Locations.[Burglar Alarm 5], Locations.[Fire Alarm 5], Locations.[Protection 5], Locations.[Building Limit 5], Locations.[Business Property Limit 5], Locations.[Laptops 5], Locations.[Field Equipment 5], Locations.[Business Income Limit 5], Locations.[Accounts Receivable 5], Locations.[Valuable Papers 5], Locations.[Location 6], Locations.[Cresta Zone 6], Locations.[Construction 6], Locations.[Age of Building 6], Locations.[Sq Ft 6], Locations.[Sprinklered 6], Locations.[Burglar Alarm 6], Locations.[Fire Alarm 6], Locations.[Protection 6], Locations.[Building Limit 6], Locations.[Business Property Limit 6], Locations.[Laptops 6], Locations.[Field Equipment 6], Locations.[Business Income Limit 6], Locations.[Accounts Receivable 6], Locations.[Valuable Papers 6], Locations.[Location 7], Locations.[Cresta Zone 7], Locations.[Construction 7], Locations.[Age of Building 7], Locations.[Sq Ft 7], Locations.[Sprinklered 7], Locations.[Burglar Alarm 7], Locations.[Fire Alarm 7], Locations.[Protection 7], Locations.[Building Limit 7], Locations.[Business Property Limit 7], Locations.[Laptops 7], Locations.[Field Equipment 7], Locations.[Business Income Limit 7], Locations.[Accounts Receivable 7], Locations.[Valuable Papers 7], Locations.[Location 8], Locations.[Cresta Zone 8], Locations.[Construction 8], Locations.[Age of Building 8], Locations.[Sq Ft 8], Locations.[Sprinklered 8], Locations.[Burglar Alarm 8], Locations.[Fire Alarm 8], Locations.[Protection 8], Locations.[Building Limit 8], Locations.[Business Property Limit 8], Locations.[Laptops 8], Locations.[Field Equipment 8], Locations.[Business Income Limit 8], Locations.[Accounts Receivable 8], Locations.[Valuable Papers 8], Locations.[Location 9], Locations.[Cresta Zone 9], Locations.[Construction 9], Locations.[Age of Building 9], Locations.[Sq Ft 9], Locations.[Sprinklered 9], Locations.[Burglar Alarm 9], Locations.[Fire Alarm 9], Locations.[Protection 9], Locations.[Building Limit 9], Locations.[Business Property Limit 9], Locations.[Laptops 9], Locations.[Field Equipment 9], Locations.[Business Income Limit 9], Locations.[Accounts Receivable 9], Locations.[Valuable Papers 9]
    FROM [PPAC Main] INNER JOIN Locations ON [PPAC Main].[TAM Code] = Locations.[TAM Code]
    WHERE ((([PPAC Main].[TAM Code])=[Enter the TAM Client Code]));

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    They don't show if you enter the correct code? Is the corresponding code in the Locations table?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  7. #7
    qbc is offline Advanced Beginner
    Windows 2K Access 2003
    Join Date
    Aug 2009
    Posts
    30
    Yes the corresponding TAM code is in the Location table.
    I enter a new record through the form and it records in the table.
    But when I search for the record in the form, it cannot find it.
    If I were to try and enter the same TAM code in the form, it will not accept it as it is the primary key but you cannot see it.

  8. #8
    qbc is offline Advanced Beginner
    Windows 2K Access 2003
    Join Date
    Aug 2009
    Posts
    30
    i think i figured it out.
    I needed to fill completely fill out the form so it wrote to both the locations table and the main table.

    thanks so much for your help. pbaldy

  9. #9
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Glad you got it sorted out.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 3
    Last Post: 08-23-2011, 04:35 PM
  2. Access 2007 doesn't show Stored Procedure option
    By DistillingAccess in forum Programming
    Replies: 0
    Last Post: 08-03-2010, 03:19 AM
  3. Replies: 1
    Last Post: 02-13-2010, 12:44 PM
  4. Chart doesn't show data
    By pbaxter in forum Forms
    Replies: 5
    Last Post: 01-20-2010, 11:09 AM
  5. Replies: 1
    Last Post: 07-12-2009, 05: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