Command(s) to clear a subform

[msmithtlh]

I have a subform based on a related table. I have a button to create a new record in the related table. I need a command or commands to clear the subform when the button for creating a new record is clicked.

Here is the code I have in the 'on click' event. Note the comment "clear the form," is where I want to put the command(s).



Private Sub cmdNewbtn_Click()

Dim tempnum As Long
Dim recnum As Long

DoCmd.RunCommand acCmdRecordsGoToLast

tempnum = TeamID
tempnum = tempnum + 1

'clear the form

DoCmd.RunCommand acCmdRecordsGoToNew
Me.TeamID = tempnum

End Sub

[Bulzie]

Have you tried using the LinkMaster and LinkChild parameters on the Subform? This links your sub table to the main table and if you go to a new record on the main table, it will then create a blank record on the sub form/table and insert the main table record key ID in that subtable if you enter data there. Then you would not have to use any code.

So the above code is run on the main form and once done you will be on a new record for the Main form with the next TeamID value, is that right? And the subform values would have remained from the previous TeamID or record so that form is not tied to the main form?

[msmithtlh]

I think this is probably the key to my problem. But it raises another question - can you have a subform inside another subform? My data has 3 levels.

Thanks.

[Micron]

I believe the max nested subform levels is 7. If your 2nd level subform is to be based on records of the 1st level subform, then you're out of luck wrt Master/Child link between those 2 subforms. However, there might be a work around you can use. Here's one on that subject (see "A subform cannot link...")

https://www.fmsinc.com/microsoftacce...edSubforms.asp