Calculated Field in a Form

C

Clifford S. Morton

I have a query that calculates a special total by account
number. I would like to create a text box in the
maintenance form so that when someone selects an account
via the form, the text box will reference that account
number and pull the total for that account from the query
and show it. I tried using the DLookUp Method, but I
can't get the criteria section to reference the form.
Perhaps I am going at this the wrong way. Anybody have
any ideas?
 
J

John Vinson

I tried using the DLookUp Method, but I
can't get the criteria section to reference the form.
Perhaps I am going at this the wrong way.
Click to expand...

That's quite possible, DLookUp takes some getting used to! Care to
post what you've tried and what result you're getting?
 

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

Page numbering with Merged Document and IF statements 1
Sum Calculated Field Question 1
Some mail merge fields not pulling into document 2
Default Value on Form Help 1
totaling in a filtered form 2
Calculating a text box 10
Form/subform totals don't balance when subform empty 1
numerical summation to passed from sub to main form 2

Top