Calculated Field in a Form

  • Thread starter Thread starter Clifford S. Morton
  • Start date Start date
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?
 
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?
 
Back
Top