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.

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.

--
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.

"Bonaco" <(E-Mail Removed)> wrote in message
news:add67aae-392e-4d18-bb79-(E-Mail Removed)...
>
> 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.

On Nov 5, 11:44*am, "Allen Browne" <AllenBro...@SeeSig.Invalid> wrote:
> 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.
>
> "Bonaco" <bonacor...@gmail.com> wrote in message
>
> news:add67aae-392e-4d18-bb79-(E-Mail Removed)...
>
>
>
>
>
> > 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.