Recent content by greensleeves149

Awesome. Thank you arnelgp. Haven't used the BeforeInsert before either. I'll try that option too.

Thanks Gasman. I didn't think of going about it that way. That's a nice clean way of doing it.

Thank you CJ_London for your tips and help too. I'll experiment with the gotfocus event- never had to use it before.

Hi all. I've got a form with combo box the main form and also have a subform. The combo box stores a numerical "ID" of the control whilst displays the text value. I was just wanting a simple messagebox when someone enters data in one of the fields in the subform and the user has forgotten to...

Thanks for clarifying Pat. I have to admit I get confused of which property to use but this makes it clearer. RE Multiple Threads- I did start to put this question originally in my first thread to save time and then I deleted it thinking that that was a question/thread around how to identify...

Super! That works perfectly- I didn't think of adding them and wouldn't have known to add the Nz. Thanks a lot for your help arnelgp and for teaching me something too. Very much appreciated.

Hi all, I have a form with two subforms on it. Both subforms have a "total" summation in the footer section of each form. On the second form, when a user updates the quantity for a line item, I currently have some code on the 'AfterUpdate' property of the 'Quantity' control, which should check...

Thanks Gasman. I actually saw that before posting in this thread some hours ago, but I still managed to get it wrong!

Thank you for clarifying the 'current' record. That makes sense. For this particular application, I was comparing records of a summed total in the footer of both subforms. The first subform contains data about the number of products that are available for allocation (more like a read only...

Hi keniny04, This is super easy to understand and I now clearly get how to do it. Thank you for showing me both options too. It makes sense. Appreciate you and The_Doc_Man for teaching me this.

Thank you The_Doc_Man.

I'm sorry, I don't know what the BrowseTo method is. Within the open form (and obviously two subforms that reside in it), I want to check the value of on control on subform1, against the value of another control on Subform2 and fire up a messagebox if certainly conditions are met. But with...

Hi guys, I've got a form with two subforms on it. (The form's name is "PrepOrders" in case this info is required) I'm not sure (even after reading and watching a few demo's) how to correctly refer to one of the subforms control? I have this code: If Me.AllocatedTotal >...

Hi Bob, Thanks so much for showing me how to do this. I totally agree that the table design is not the best for inventory control- in my example database here, I tried to create an example of what I was trying to achieve, so the setup is a little different to my actual database. Part of that...

Thanks Ranman256. I understand your logic here, but I don't know how exactly to apply it with references to the subforms.