What event can I use to solve my problem ?

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
 
A

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

link subform within subform 0
IM requery event to play sound 1
Return focus to form 4
Forms property using varables 2
How do I set focus (and select text) on a text box on a modeless userform? 0
requery on parent form looses original record 1
Save on Second form 4
Problem with Selected() and Requery on form 0

Top