Hello, I have recorded a macro to perform a database query, but I would like an input box to prompt the end user to enter the data they would like to query.
This is the department ID (e.g. 123456)
I have so far got the following code:
How can I get my variable 'ccode' to replace the DeptDB.Departmentcentre value (123456) ?Please Login or Register to view this content.
"WHERE (DeptDB.Departmentcentre='123456') A"
Cheers
Tom
Bookmarks