A form's RecordSource can be a table, a query, or an SQL statement. Use either query or SQL with criteria parameter to filter the form's records. I am not sure what your confusion is. Follow the tutorial.
VIP
Windows XP 
Access 2010 32bit
A form's RecordSource can be a table, a query, or an SQL statement. Use either query or SQL with criteria parameter to filter the form's records. I am not sure what your confusion is. Follow the tutorial.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
If Statement Criteria Needed for form
Iif statement with multiple criteria
Posting Permissions
Reply With Quote