Hello, I'm very new with Macros. But I've got a small problem that I think wouldn't be much of a problem for someone with a little more experance with the subject.
I have a form, It asks for name, address and other details. At the bottom of the page i've got a combo box that has two options,
1. database 1
2. database 2
I've also got a button, I would like the button to open up Database 1 if that one is selected in the combo box, Or database 2 of database 2 is selected.
I put in a button and used to expression builder to setup the macros as follows,
[Forms]![Test Form 1]![database]="Database1" Open form
[Forms]![Test Form 2]![database]="Database2" Open form
When I run this i get a 'Type mismatch' error.
When i remove the conditions it opend up both database1 and 2 when i press the button.
I've been searching online for any help for the last few hours and it's very annoying as i can't seem to find anything that can help,
Thanks for your time,