closing a dialog box

D

Dick Minter

I have added code to a form to trap the error when the user attempts to enter
an unmatching entry into a combo box field (that restricts entries to a
list). The code calls a (modal) dialog box that allows the user to open a
form for updating the combo box source table. The problem: how do I close
the dialog box before opening the second form?

DM
 
R

Rick Brandt

Dick said:
I have added code to a form to trap the error when the user attempts
to enter an unmatching entry into a combo box field (that restricts
entries to a list). The code calls a (modal) dialog box that allows
the user to open a form for updating the combo box source table. The
problem: how do I close the dialog box before opening the second
form?

DM
Click to expand...

DoCmd.Close acForm, Me.Name
DoCmd.OpenForm "FormName"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Multiple Fields without Dialog closing between each... 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Data Entry VBA 4
Testing for required data entry in form fields. 6
Data entry for a table from a form 1
See new record in puCombo Box 2
Macro Code for bringing up Save As dialog box and changing file Type 0
Enter Parmeter Dialog Box 1

Top