I'm having some trouble figuring out a good way to conditionally format some items in a form / subform relationship. Basically, I have a form called frm_TruckManifest with a subform called frm_TruckManifest Subform. They are linked child to master properly and the design actually works pretty well. However, what I want to do is conditionally format a set of fields based on the subform.
For instance, I have a field in the main form called 'Part Number' with a specified quantity that is stored on a table called tbl_Orders. I have another table called tbl_Trucks that has information for the day it left our facility and expected arrival date/time at it's destination. We fill the truck using a junction table as tbl_TruckOrder. There, the Part Numbers are loaded to each truck. I want the main form 'Part Number' field to be red until the specified amount has been loaded to the subform. Is that even possible? I've tried a bunch of count and DCount but nothing has worked. Since I couldn't figure out what the problem was I created a txt box just to count the records on the subform but I can't even get that to work right. I just want the text box to count how many of X part number are on this truck.
For instance, I have a field in the main form called 'Part Number' with a specified quantity that is stored on a table called tbl_Orders. I have another table called tbl_Trucks that has information for the day it left our facility and expected arrival date/time at it's destination. We fill the truck using a junction table as tbl_TruckOrder. There, the Part Numbers are loaded to each truck. I want the main form 'Part Number' field to be red until the specified amount has been loaded to the subform. Is that even possible? I've tried a bunch of count and DCount but nothing has worked. Since I couldn't figure out what the problem was I created a txt box just to count the records on the subform but I can't even get that to work right. I just want the text box to count how many of X part number are on this truck.
