form logic

[klp via AccessMonster.com]

I'll try to explain the best I can. I have an customer orders form, w/ the
order lines being the subform. When a csr is going to enter in a new order, I
would like for an pop up form to open up as they enter in a part number if
it's specific criteria. For example, if any part number has a stop or a
warning on it I want my pop up form to come up. So what I did was on my
ItemID field, afterupdate, I put logic there as follows:
If me!CustOrderStop = 1 or 2 then
DoCmd.OpenForm "frmCustOrderStopMsg"
Endif

I need for the id to be carried to that form. How do I do that? I've tried a
few different ways and it's not even recognizing my code.

thanks in advance.

KimP

 

[Douglas J. Steele]

If all you want is to display the form with only that specific product on
it, use something like:

DoCmd.OpenForm "frmCustOrderStopMsg", _
Wherecondition := "ProductId = " & Me.ProductId

 

[klp via AccessMonster.com]

Ah ha. I tried everything but that and it was so simple. Thank you so much!

If all you want is to display the form with only that specific product on
it, use something like:

DoCmd.OpenForm "frmCustOrderStopMsg", _
Wherecondition := "ProductId = " & Me.ProductId

I'll try to explain the best I can. I have an customer orders form, w/ the
order lines being the subform. When a csr is going to enter in a new

[quoted text clipped - 14 lines]

KimP