Some Explanation with Access Query

[firoz.raj]

can anybody tell why this Ms Access query is not working .Kindly let me know the idea.Any help would be highly appreciated.

SELECT AccessRole.emp_ID, AccessRole.FormID
FROM AccessRole
WHERE AccessRole.emp_ID='281' and AccessRole.Form_id='4';

 

[vbaInet]

Use this:

SELECT AccessRole.emp_ID, AccessRole.FormID
FROM AccessRole
WHERE AccessRole.emp_ID=281 and AccessRole.Form_id=4;

When you are setting a criteria that refers to a numeric value, don't use quotes, e.g.
AccessRole.emp='281'

That is used for strings.