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