Help with VB Code to open a popup window on the "After Update" event

[Del]

I have a database that is used to process customer orders. This
databse has numerous tables and forms the table involved in this
question is called tblCustomerMaster. There are two forms in question
one called frmReviewOrder, and the other called frmCreditHold

On the tblCustomerMaster table there is a check box for credit hold.
This is used to signify a customer that is not allowed to order goods
because of some credit issue.

On the frmReviewOrder form there is a drop down combo box for the
Customer's ID number, called CustNbr. Once the user selects the
Customer Number from the drop down I would like Access to look up that
CustNbr at the tblCustomermaster table and if the CreditHold check box
is True them I want the frmCreditHold form to open. If the creditHold
check box is false (not checked) I want Access to continue on (Do
nothing).

Thank you for any assistance!

Regards,
Del

[Ruskin]

Try something like;

Private Sub cboCustomer_Click()
If DLookup("[Credit Hold]","tblCustomerMaster", _
"[Customer ID]='" & cboCustomer & "'") Then
DoCmd.OpenForm "frmCreditHold", acNormal, , , , acDialog
End If
End Sub
"Del" <dt****@yahoo.com> wrote in message
news:c2**************************@posting.google.c om...

I have a database that is used to process customer orders. This
databse has numerous tables and forms the table involved in this
question is called tblCustomerMaster. There are two forms in question
one called frmReviewOrder, and the other called frmCreditHold

On the tblCustomerMaster table there is a check box for credit hold.
This is used to signify a customer that is not allowed to order goods
because of some credit issue.

On the frmReviewOrder form there is a drop down combo box for the
Customer's ID number, called CustNbr. Once the user selects the
Customer Number from the drop down I would like Access to look up that
CustNbr at the tblCustomermaster table and if the CreditHold check box
is True them I want the frmCreditHold form to open. If the creditHold
check box is false (not checked) I want Access to continue on (Do
nothing).

Thank you for any assistance!

Regards,
Del

[Del]

Worked like a champ.

Thank You!!!

Del

"Ruskin" <ru******@nospam.xtra.com> wrote in message news:<uh*******************@news.xtra.co.nz>...

Try something like;

Private Sub cboCustomer_Click()
If DLookup("[Credit Hold]","tblCustomerMaster", _
"[Customer ID]='" & cboCustomer & "'") Then
DoCmd.OpenForm "frmCreditHold", acNormal, , , , acDialog
End If
End Sub
"Del" <dt****@yahoo.com> wrote in message
news:c2**************************@posting.google.c om...

I have a database that is used to process customer orders. This
databse has numerous tables and forms the table involved in this
question is called tblCustomerMaster. There are two forms in question
one called frmReviewOrder, and the other called frmCreditHold

On the tblCustomerMaster table there is a check box for credit hold.
This is used to signify a customer that is not allowed to order goods
because of some credit issue.

On the frmReviewOrder form there is a drop down combo box for the
Customer's ID number, called CustNbr. Once the user selects the
Customer Number from the drop down I would like Access to look up that
CustNbr at the tblCustomermaster table and if the CreditHold check box
is True them I want the frmCreditHold form to open. If the creditHold
check box is false (not checked) I want Access to continue on (Do
nothing).

Thank you for any assistance!

Regards,
Del