I have a form with 3 drop-down lists with the names, say, Control1, Control2, Control3.
Control 1 - numeric
Control 2 - text
Control 3 - memo
I am trying to make a button which opens up a form, Form1, based on what is selected in these three textboxes. Control1 will look up the values in Field1, Control2 the values in Field2...(all from a table, Table1, on which Form1 is based.)
However, there seem to be syntax errors in my VB stLinkCriteria statement.
I need the correct syntax to get the button to open Form1 with valid records based on the list box selections.