Hi,
Please bare with me as I ask the questions below...I am not quite sure how to explain what I am talking about, but I am going to give it a shot. I have been working on a particular form in my database that has tabs built into it. I may have built this wrong, but I will explain what I did. My first tab is the "Main Details" tab - this is populating my order assignments table. The second tab is the "status information" tab - which is also populating the order assignments table. I used a subform to put that information on the second tab (which I am thinking maybe I shouldn't have done). The Third tab is the "NCR log" tab - which populates a different table, my ncr table, and the Fourth Tab is the "SR Log" tab - which populates a third table, my SR table.
The information populates all of the tables correctly as I have them set up right now.
I went into the properties of my Form and locked the form from any editing, additions or deletions, then I created a button on the top of my form that has to be clicked to turn those features back on.
I used the following code behind the button:
Me.AllowAdditions = true
Me.AllowEdits = true
Me.AllowDeletions = true
The code worked perfectly to turn back on the editing functions on the form on the MAIN DETAILS tab of my form. Here is where I hit my problem. If I am entering information on a NEW record, and I go to click from my main details tab to my status information tab (which contains the subform that populates the same table as the main details tab) the sub form does not appear on the tab. The subforms do not appear on the third and fourth tab either. After looking at other records in the database that DO have information in them already, I am assuming that the new record's tabs do not show the subforms if there is no information populated in the fields of the tables that the forms are based on.
If I am wanting to have that second tab show the sub form with the blank fields, how do I make that happen? I want the form to always show information.
If I remove the Button and change the form back to allow all additions/edits/deletions, this problem goes away.
Any help someone can give me on this would be greatly appreciated.
I can be emailed at tricia77@bellsouth.net
Thanks so much!!!!!!