Search results

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.

Hi all, I've got a database which records purchases and sales. What I'm trying to do is if say we have 20 Units of Product A available, to stop a user from accidently entering anything over 20 sales of Product A. The same should be applied for Product B, C etc. I've been unsuccessful for a...

Awesome- thank you arnelgp

Hi Bob, Thank you for the time you have taken to put these two solutions to me- very much appreciated. When selecting a product, your fix updates the respective UPC, Size and Variety perfectly- just as I wanted. In testing, I've found some unexpected behavior. 1) Let's say I change the...

Hello all, I have a Combo box (ProductName) on a continuous form (this form will be used as a subform) and what I was trying to do, was when the user updates/selects a Product, the respective UPC, Size and Variety fields will automatically populate for that line item. I'm not sure how to...

Hi all, Just a small update to all of you that gave me help and advice, after taking the time to rebuild the database bit by bit and test inbetween stages (testing each query, form etc), the new one seems to be working ok now. Thank you for all your time and help. That method appears to have...