Preventing a duplicate record from being added on an order form

[Kipandrews06]

Gicu, I tried the code and it gave me an error message saying "method or data member not found" for the Me.QtyOrdered. Since this is on the cmd button on the product list subform, there isn't a qtyordered field. I tried doing [forms]![frmItemCartOrdersSubform].[QtyOrdered] but it said it couldn't find referenced field. I then tried it including the main form since its all linked [forms]![frmOrderDetails]![frmItemCartOrdersSubform].[QtyOrdered] but got the same error message. Should I try an invisible dlookup txt box to reference it?

[Kipandrews06]

Here's a screenshot of my table and the form with the subforms.

[Gicu]

Try Me.Parent.Form.[frmItemCartOrdersSubform].Form.Controls("QtyOrdered") or
Forms![frmOrderDetails]![frmItemCartOrdersSubform].Form.Controls("QtyOrdered")

Cheers,

[Kipandrews06]

Gicu, that worked and is doing exactly what I wanted, but now it is not updating. When I start a new order and click on the add button it just flashes for a sec and the message box that is supposed to pop up to say "Item Added to Cart" doesn't show. When I go to the table those products were added. I'm looking at the code and I clearly have it set to requery. I'm not sure why its not doing that step. But when I add the same product twice it combines the duplicate value with the other product so that is working perfect!

[Gicu]

Please post the entire code as you have now, I think the Me.Requery and the MsgBox needs to move outside the If statement (just checked and I forgot to add the End If in my original post).

Cheers,

[Kipandrews06]

Actually, I fixed it. I needed to put the ELSE part under the form requery I had. So anyways, thank you so much for your help! Everything is working perfect now!

[Kipandrews06]

Just saw your post Gicu and you are correct. I also moved up the msgbox as well before the ELSE part.

[Gicu]

You're very welcome, see, it wasn't that hard if we approach it one step at the time !
Cheers,