Maybe I'm just saying it wrong (I'm self taught so my "jargon" leaves something to be desired) because I feel this is pretty fundamental and used a lot... but I've hit {yet another} wall in finding info. I'm already a solid month behind on this project so any help would be massively appreciated (by me and my poor employees who are way overdue on a better system).
I have a Project form, which holds StockArtProduction_Subform in datasheet view. I need for them to be able to click on the ID in the StockArtProduction_Subform datasheet and it open a single view form (StockArtProduction) with the correlating ID.
Ideally, it would also work for new entries in the StockArtProduction_Subform, but the StockArtProduction form would have to "auto populate" (did I use it right?) with the ID of the currently open Project form.
Again, our sanity and general well-being thanks you in advance.
I have a Project form, which holds StockArtProduction_Subform in datasheet view. I need for them to be able to click on the ID in the StockArtProduction_Subform datasheet and it open a single view form (StockArtProduction) with the correlating ID.
Ideally, it would also work for new entries in the StockArtProduction_Subform, but the StockArtProduction form would have to "auto populate" (did I use it right?) with the ID of the currently open Project form.
Again, our sanity and general well-being thanks you in advance.
