form logic

  • Thread starter Thread starter klp via AccessMonster.com
  • Start date Start date
K

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
 
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
 
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
Click to expand...
[quoted text clipped - 14 lines]
KimP
Click to expand...
Click to expand...
 
Back
Top