where condition (isnotnull)

[benzan]

im trying to open form passing few criterias and i can't seem to find a way to find a way to select records that are dirty.

DoCmd.OpenForm "frm_purchasereqedit", , , "[StaffID] = Forms!frm_LogIn.txtStaffID And [budgetkey]=isnotnull"

i've tried doing [budgetkey]="dirty" and so forth but it's still looking for the matching field (dirty) instead of is not null records..

any way i can accomplish this?

 

[genomon]

[budgetkey]=isnotnull bad.

[budgetkey] IS NOT NULL good.

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."