Search results

yeatmanj, i tried replacing it with what you have suggested for Access 2000, but it still comes up with the error message: "You entered an experession that has an invalid reference to the property RecordSource". Error code is "2455"

I tried it without the .Form part but that gave me an error message saying: "Method or Data Member Not Found" so I think it's meant to be there

yeah that part: Me.subfrmTest.Form.RecordSource = searchSQL is it written differently for access 2000 & 2003? Sorry about the double post, i forgot to delete it when I thought it was better to post this topic in the VBA section. I've already deleted the other thread in the query section.

Hi, I'm just wondering if there is any differences in writing queries in vba in different versions of access. i'm developing a search function in access 2000, but it doesn't seem to be working. however, the same code in access 2003 works fine. Here's an extract of the code when the search...

Is there a way of setting the columns of a subform, to what ever columns are used when a query is run? The query itself takes in user input and based on those requirements it displays the result in the subform. So, the columns of the subform (in datasheet view) doesn't stay constant.

Hi, I'm just wondering if it's possible to display the result of a query on a subform which does not have a relationship with any other table. What I'm doing is creating a search form where a query is built from the users input (through combo boxes and text boxes) of what table, attribute and...