469,917 Members | 1,763 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,917 developers. It's quick & easy.

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
Nov 12 '05 #1
2 2022
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
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.

Similar topics

3 posts views Thread by David | last post: by
3 posts views Thread by Kevin Pedersen | last post: by
3 posts views Thread by Rich | last post: by
13 posts views Thread by Bob Day | last post: by
4 posts views Thread by injanib via AccessMonster.com | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.