I think I understand the theory of what I'm trying to do here, but being brand spankin new to VBA I've only got half of the idea working so far:
I have a Project form, which holds StockArtProduction_Subform in datasheet view. I have it able to click on the ID in the StockArtProduction_Subform datasheet and it open a single view form (StockArtProduction) with the correlating ID thanks to this code
DoCmd.OpenForm "FStockArtProduction", , , "ID = " & Me.ID
YAY (thanks PBaldy)! But now I need a resolution for new entries of the StockArtProduction_Subform in datasheet view. My theory is something along the lines of:
If ID is null then open form StockArtProduction with new entry where ProjectID = ProjectID from Projects that is currently open.
But for some reason that didn't work when I plugged it in
.
Please please please help. This is literally the last step other than clean up in this saga of a database. This forum has been invaluable and I can not thank everyone enough for that.
I have a Project form, which holds StockArtProduction_Subform in datasheet view. I have it able to click on the ID in the StockArtProduction_Subform datasheet and it open a single view form (StockArtProduction) with the correlating ID thanks to this code
DoCmd.OpenForm "FStockArtProduction", , , "ID = " & Me.ID
YAY (thanks PBaldy)! But now I need a resolution for new entries of the StockArtProduction_Subform in datasheet view. My theory is something along the lines of:
If ID is null then open form StockArtProduction with new entry where ProjectID = ProjectID from Projects that is currently open.
But for some reason that didn't work when I plugged it in

Please please please help. This is literally the last step other than clean up in this saga of a database. This forum has been invaluable and I can not thank everyone enough for that.
Last edited: