DLOOKUP Not Updating Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a form with several fields. Two of those fields use DLOOKUP to
auto-fill that field. The DLOOKUP function works perfectly in the form.
However, the data from the DLOOKUP fields do not update the table. All other
fields in the form update the table properly.

Any insight is greatly appreciated.

Access 2002
 
Gator said:
I've created a form with several fields. Two of those fields use DLOOKUP to
auto-fill that field. The DLOOKUP function works perfectly in the form.
However, the data from the DLOOKUP fields do not update the table. All other
fields in the form update the table properly.

Any insight is greatly appreciated.

Access 2002
Click to expand...

A control which determines it's value using Dlookup is a calculated control
and hence cannot be not bound to a field in the form's recordsource.

If you can calculate the value you are interested in, then that value is, by
definition, derived data, and so you do not need to store it in the
database. Simply calculate it whenever you need to display or report it.
 
Brian said:
A control which determines it's value using Dlookup is a calculated control
and hence cannot be not bound to a field in the form's recordsource.

If you can calculate the value you are interested in, then that value is, by
definition, derived data, and so you do not need to store it in the
database. Simply calculate it whenever you need to display or report it.
Click to expand...

Sorry, there was an inadvertant double negative in my previous reply. The
first sentence should of course have read:

A control which determines it's value using Dlookup is a calculated control
and hence cannot be bound to a field in the form's recordsource.
 
Back
Top