Macro Code or Form code?

[EagleOne]

2003

Currently 1st time design/use of form.

I am not sure how to code a form. Is there a wizard? Does creating a form
and/or buttons generate any code?

The form will have 4 radial buttons.

I would like the form to open on FileOpen

Would like the user to select any, or up to all, radial buttons.

I do not know where to place the code. (What is macro code vs form code?)


Macro????
OnOpen
Open MainForm

Button #1 (If checked on MainForm)
Run query #1
Copy results to c:\Reports\Results#1.mdb
Button #2 (If checked on MainForm)
Run query #2
Copy results to c:\Reports\Results#2.mdb
Button #3 (If checked on MainForm)
Run query #3
Copy results to c:\Reports\Results#3.mdb
Button #4 (If checked on MainForm)
Run query #4
Copy results to c:\Reports\Results#4.mdb

Thanks in Advance
EagleOne

 

[Wayne-I-M]

Yes there is a wizard for all these

Open the switch board in design view and the the tool box. Select the
button icon and follow the instrcutions (there is one to open the form)

Open the form in design view and do the same but this time follow the same
instructions to open/run the query(s)

 

[EagleOne]

Thanks Wayne form MOE!