Windows 7 64bit 
Access 2007
I've been opening a split form to the first record on that form from a multi column combo box on the main form(with sub forms) that limits the records shown to those matching one of the columns in the combo box. It has been working with single criteria, but now I'd like to open it and use another piece of criteria to move to the specific record on that split form. I have attached the code and screen shot of the form.My problem is I'm getting an error and I've tried a bunch of ways (syntax) and can't seem to get it to work. Could someone have a look and maybe tell me what my "AND" where clause should look like. Thank You.
Reply With Quote
