Advertisement

06.04.2008 at 05:19PM PDT, ID: 23458816
[x]
Attachment Details

Forms Open/Close Vs Visible/Invisible Vs OpenArgs

Asked by MG_Janiszewski in Access Forms, Access Architecture/Design, Access Coding/Macros

FormA   (switchboard)   field1 are JobOrders     field2 are subJobOrders      
field1                                                                          field2
cbobox                                                                      cbobox
AfterUdate looks for the all or one subJobOrders    AfterUpdate Together field1 and field2 Opens
                                                                                  Form B  which inputs  field1 and field2 into tblMain
FormB has three command buttons
cmdbutton1                                                  cmdbutton2                                  cmdbutton3
Docmd.Close (Closes FormB)                    Docmd.Close (Closes FormB)      cmd.Close                                
Docmd.OpenForm  FormA                          Docmd.CloseA                                        
I do this to bring FormA in order to Add     Docmd Open A
More field2 to the same field1                    I do this to clear the cboboxes
                                                                  so I can choose Another Joborder
Is the another way (easier way) to clear cboboxes without closing and reopening the form?Start Free Trial
 
Loading Advertisement...
 
[+][-]06.04.2008 at 06:25PM PDT, ID: 21715763

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Access Forms, Access Architecture/Design, Access Coding/Macros
Sign Up Now!
Solution Provided By: capricorn1
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628