What event can I use to solve my problem ?

  • Thread starter Thread starter Albert
  • Start date Start date
A

Albert

Hello,

I have a button on form1. When click, It will generate data for RecordSoure
for form2 and then open and requery form2. In form 2, I have a module level
variable (called BalanceQty) which have to be initialized every time form 2
is requeried. But how to do that , Where should I put my code ? I can not
found any event to be triggered when form is requeried.

TIA,
Albert
 
Oh! I forget to explain a little bit more. Form 2 is continuous form and
BalanceQty is used for sum (plus or minus depend on In or Out qty) of each
qty and is displayed on each line. Form 2 is used as a stock card . In my
case, On Current can not be used. (If my form is Single form, your method is
OK.)

Thanks,
 
Back
Top