Solved

Report Unbound field value based on another fields contents

Posted on 2002-04-04
3
164 Views
Last Modified: 2012-05-04
I am trying to actively set the value of an unbound field based upon the value of another field:

Set Me!Name = queries!qryTeamName where Me!NameID = queries!qryTeamID

I can't do this in the underlying query do to inner join violations.

Is there any way to get this done, or do you have any other suggestions?

Thanks,

tcoc
0
Comment
Question by:tcoc
  • 2
3 Comments
 
LVL 54

Accepted Solution

by:
nico5038 earned 100 total points
ID: 6919441
For this normally a DLOOKUP is used.
Syntax:
=DLOOKUP("Teamname","qryTeamname","Me!NameID="&me.teamid)

This assumes that the field teamid is (hidden?) on the report.

Nic;o)
0
 

Author Comment

by:tcoc
ID: 6919481
Nic,

You da Man!  I forgot to try that - duh!

TeamId is hidden in the report.

Working syntax = DLookUp("Name","qryTeam","TPM=teamid")

Thanks for quick response too!

tcoc

0
 
LVL 54

Expert Comment

by:nico5038
ID: 6919498
You're welcome, the quick response is just luck as I'm now off to bed ;-)

C U

Nic;o)
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now