By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,486 Members | 2,152 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,486 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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


Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.