only show record which consists "field" and "exp"

[wshs]

I've been struggling with this for awhile..
I have a "option" form, which has a command button,"cmdWV"
when user clicks cmdWV, form "frm_psc_voucher" opens.

here's the problem. form frm_psc_voucher is related to frm_psc_new. Two seperate forms but user first write contracts on frm_psc_new and when user selects frm_psc_voucher, it needs to only show his/her(staffID) record. and also only where the "balance" is > 0..
i've tried doing Link Criteria on click of cmd button, on open of form, and if fuction using DLookUp.. yet i can't figure this out.. can someone please give me some advice on which direction i should be going?

 

[CLMooreJr]

Maybe I'm oversimplifying this, but could you just have frm_psc_voucher populate from a query? You could then, when they click on the Voucher button, ask for the StaffID. The query linked to the table could have the StaffID criteria set to [Enter Staff ID] and the balance field criteria could be set to >0.

It would then populate the form with all matching records from the associated table....

 

[wshs]

do you see any other ways w/o using a query? pref. vba?

 

[wshs]

i just stuck /w query..

DoCmd.OpenForm "frm_psc_voucher", , "qry_psc_voucher_currentuser