Really need help with this

J

Joe Cilinceon

I have a Payments Form that has a subform for entering charges. This subform
uses a temp table to store what is entered in it. I select a charge from a
combo box on the subform and enter an amount. Now nothing is saved until I
hit a button to post the payment and at that time my DB us updated. I'm
trying to trap ChgAmt that has an ChgID = 13 to a variable so I can perform
a calculation with it in the post payment procedure. I've tried DLookup but
have had no luck with that so far. The temp table is name PaymentCharges and
the subform is fsubPayChg.
 

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

Combo Box on a Subform 5
Subform record validation 2
Need subform total on main form ? 1
Another Question on Subforms 2
How force table update when no bound field updated? 1
Form for payments - Access 2003 3
Insert Into and automatic record entry 17
validation 4

Top