DlookUp

  • Thread starter Thread starter Alex H
  • Start date Start date
A

Alex H

In a form i have a table of which one field uses the following dlookup as
the control source.
=DLookUp("[CourseCost]","[tblCourseInformation]","[CourseID]=[CourseUndertaken]")

Althoiugh the correct data is appearing in the form, the data is not being
saved if i look at the table

What am I doing wrong please?
Tks
A
 
Alex said:
In a form i have a table of which one field uses the following
dlookup as the control source.
=DLookUp("[CourseCost]","[tblCourseInformation]","[CourseID]=[CourseUndertak
en]")

Althoiugh the correct data is appearing in the form, the data is not
being saved if i look at the table

What am I doing wrong please?
Tks
A
Click to expand...

In order for a form control to save data into the underlying RecordSource it
must have a ControlSource entry that is the name of a field in that
RecordSource. In your ControlSource you have an expression, not the name of
a field.

A control is either bound or contains an expression. It cannot do both.

The good news is that if you can display what you want with an expression
then it should be completely unneccessary to save the data to the table.
Just use the expression any place you need that value.
 
Back
Top