bound to the expression....

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

Guest

Hi,
Im working on a form that has the 'activities field' wich doesnt change very
often.
Ussualy, when it comes a new day or record it has to have the yesterday's
activity written. To do that I used the Dlookup funcion as follows:

=DLookUp("[Activities]";"Table";"[ID]=Forms![TableForm]![ID]-1")
And works fine, but when is necessary to add something or change the record
I get the message that says "bound to the expression...Dlookup..."
It is possible to have the expression and allow the user to edit the field
if he wants to change the old activity??

Thanks
 

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

field references in forms 5
Controlsource won't let Dlookup to enter 12
Access Macro Repeat Expression using value of a field in table 0
Dlookup Expression Error 2
Need to modify discount expression 5
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
DLookup (Or ELookup)? 3
Pulling data into a form and making it save 7

Back
Top