Macro is not working in this db. I am trying to create a command button using the wizard to open another form. (I know all of this can be done using VBA DoCmd.OpenForm…, but I am trying to see what’s causing my forms in this database to not work...)
I did the following:
1. fmainCompany is opened in Design View
2. Click command button and put on form
3. Command Button Wizard starts.
4. What action do you want to happen when the button is pressed?
5. Categories = Form Operations
6. Actions = Open Form
7. Next
8. What form would you like the command button to open? = fdlgEventDetailAdd
9. Next
10. Open the form and find specific data to display.
11. Next
12. Which fields contain matching data the button can use to lookup information?
Select the fields and then click <-> button.
fmainCompany: is blank
fdlgEventDetailAdd: has all the fields listed.
Why is fmainCompany not showing the fields?
I copied the two tables to a blank db and ran the command button wizard again and all the fields from both tables are listed.
I did the following:
1. fmainCompany is opened in Design View
2. Click command button and put on form
3. Command Button Wizard starts.
4. What action do you want to happen when the button is pressed?
5. Categories = Form Operations
6. Actions = Open Form
7. Next
8. What form would you like the command button to open? = fdlgEventDetailAdd
9. Next
10. Open the form and find specific data to display.
11. Next
12. Which fields contain matching data the button can use to lookup information?
Select the fields and then click <-> button.
fmainCompany: is blank
fdlgEventDetailAdd: has all the fields listed.
Why is fmainCompany not showing the fields?
I copied the two tables to a blank db and ran the command button wizard again and all the fields from both tables are listed.