Results 1 to 6 of 6
  1. #1
    bauer1544 is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2020
    Posts
    8

    Angry subform appears blank on my main form when I select create new record

    This may be a bit of information overload but i want to leave no stone unturned since this is a project I've been working months on to run into the same issue I was trying to avoid. Per the forum rules i have posted a similar question https://answers.microsoft.com/en-us/...=1585439828738 .



    so back to the issue at hand I have a main form that is set to control by the tblFeedstockLotData there is subform controled by tblHardnessResults and a nested subform controlled by sample results.
    Click image for larger version. 

Name:	database screenshot.jpg 
Views:	17 
Size:	126.3 KB 
ID:	41420
    here is a screenshot of the relationships.
    Click image for larger version. 

Name:	datascreenform.jpg 
Views:	17 
Size:	274.8 KB 
ID:	41421
    and here is a screenshot of the form

    the most puzzling thing to me is it was working and I don't know why or when it stopped it just did and I wish I had more information on that.

    now more information on the issues ive found.

    1: there is no data to show so therefore it comes up blank
    2: even when i add a batch number to the main form save it and close it it still doesnt create a blank line in the hardness results subform or the sample results for me to add data.
    3 if i go into the tables directly and add a feeddstock/batch number even if theres no data then everything will come up for me.

  2. #2
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Not sure I can help much without a sample db (no data, just the objects involved), but why does the subform Sample Results say Table.tblSampleResults? Have a look at te source object property of the sunform control and see if it correctly references an existing form (sfrmSampleResults).
    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  3. #3
    bauer1544 is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2020
    Posts
    8
    are you asking me to share the database with you?

  4. #4
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Yes, if you could just put the empty tables and forms (and any queries that are needed), no data or just some dummy records to replicate your problem. You can then zip it and upload it to this forum.
    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  5. #5
    bauer1544 is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2020
    Posts
    8
    I found the issue. there is a function in on current

    private sub(onCurrent)
    refresh
    checklock
    end sub
    Private Sub CheckLock()
    If chkLocked = True Then 'chkLocked is a checkbox
    lblLocked.Visible = True 'lblLocked is a label that appears when the data is locked
    Me.AllowDeletions = False
    Me.AllowEdits = False
    Else
    lblLocked.Visible = False
    Me.AllowAdditions = True
    Me.AllowEdits = True

    End If


    End Sub



    i went wrong somewhere and it was leaving allow additions and allow edits to no so i just have to fix that




  6. #6
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Glad you figured it out!
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

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

Similar Threads

  1. Replies: 10
    Last Post: 07-05-2017, 11:31 AM
  2. Replies: 6
    Last Post: 05-09-2017, 09:13 AM
  3. Replies: 3
    Last Post: 10-09-2012, 11:58 PM
  4. Replies: 8
    Last Post: 08-26-2012, 11:11 PM
  5. Replies: 5
    Last Post: 08-21-2012, 12:30 PM

Tags for this Thread

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