Results 1 to 2 of 2
  1. 01-10-2018, 02:18 AM #1
    MdHaziq
    MdHaziq is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Location
    Singapore
    Posts
    124

    No Data When Form Opens

    Dear


    Forum,

    I am having trouble figuring out, solving the problem of data not showing up when frmMaster opens for the first time.

    The data comes back when I access the cbobox filter on the header.

    Any reason why?

    TIA

    Haziq
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  2. 01-10-2018, 03:37 AM #2
    Minty
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,003
    Remove the extra bit in you open form VBA

    DoCmd.OpenForm "frmMaster", acNormal

    Is all you actually need
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. data entry form is blank when it opens, when before it was not.
    By ecalvert47462 in forum Forms
    Replies: 2
    Last Post: 03-17-2014, 09:01 AM
  2. Combo box in form set to "yes" opens a new data entry form with data from form 1
    By JulieMarie in forum Forms
    Replies: 1
    Last Post: 08-21-2013, 04:51 PM
  3. Report Opens without showing all of the data using menu
    By burrina in forum Reports
    Replies: 8
    Last Post: 01-19-2013, 04:47 PM
  4. stop the "data entry" field from changing when a form opens
    By jaymin in forum Forms
    Replies: 7
    Last Post: 01-29-2012, 07:44 AM
  5. Other Form Opens with Current Form Data upon Btn Press
    By KrenzyRyan in forum Forms
    Replies: 9
    Last Post: 04-11-2011, 10:55 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums