Bound a DLookUp Value

[Bonaco]

Hi There,

Sorry about my basic question. I did a quick search and I couldn't
realize how to solve my issue.

I'm using Access 97 and my experience on it isn't big!

I have the Dlookup working fine and geting the value that I need.

But I can not BOUND the Dlookup result.

What is the correct way to do that?

I have a Text Box with the Control Source set to my field [Last Follow
up Date] named as Last Follow Up Date

Name: Last Follow Up Date
Control Source: [Last Follow up Date]

My Dlookup that is getting the value that I want as Control Source of
a Unbound Text Box named as UnboundDLookUp

=DLookUp("[FollowupDate]![TimeStamp]","FollowupDate","[FollowupDate]!
[PlanitCode] =" & [PlanIT Code])

Name: UnboundDLookUp
Control Source: =DLookUp("[FollowupDate]!
[TimeStamp]","FollowupDate","[FollowupDate]![PlanitCode] =" & [PlanIT
Code])

So basicaly, I would like to "save" the Dlookup result in the Last
Follow Up Date field.

Thanks in advance for your assistence.

 

[Allen Browne]

The core concept is that you don't bind the result of a calculation to a
field, unless there is some valid reason why the result could be different
from the calculation.

For an explanation, see:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

The article also explains how to assign a result if you really do need to do
that.

 

[Bonaco]

The core concept is that you don't bind the result of a calculation to a
field, unless there is some valid reason why the result could be different
from the calculation.

For an explanation, see:
    Calculated fields
at:
   http://allenbrowne.com/casu-14.html

The article also explains how to assign a result if you really do need todo
that.

--
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

Sorry about my basic question. I did a quick search and I couldn't
realize how to solve my issue.

I'm using Access 97 and my experience on it isn't big!

I have the Dlookup working fine and geting the value that I need.

But I can not BOUND the Dlookup result.

What is the correct way to do that?

I have a Text Box with the Control Source set to my field [Last Follow
up Date] named as Last Follow Up Date

Name: Last Follow Up Date
Control Source: [Last Follow up Date]

My Dlookup that is getting the value that I want as Control Source of
a Unbound Text Box named as UnboundDLookUp

=DLookUp("[FollowupDate]![TimeStamp]","FollowupDate","[FollowupDate]!
[PlanitCode] =" & [PlanIT Code])

Name: UnboundDLookUp
Control Source: =DLookUp("[FollowupDate]!
[TimeStamp]","FollowupDate","[FollowupDate]![PlanitCode] =" & [PlanIT
Code])

So basicaly, I would like to "save" the Dlookup result in the Last
Follow Up Date field.

Thanks in advance for your assistence.- Hide quoted text -

- Show quoted text -

Thank you very much for the explanation Allen... I had like the first
explanation...

How do you get Access to store the result of a calculation?

For example, if you have fields named Quantity and UnitPrice, how do
you get Access to write Quantity * UnitPrice to another field called
Amount?

The best answer is, "Don't!"

I will keep the Dlookup listed on my reports and tables and I need
it to be viewed.