UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Printing records of a table w/out listing all of the all Values    
 
   
dandrew
post Jun 11 2007, 02:46 PM
Post #1

UtterAccess Member
Posts: 20
From: Orange County, Ca
I am making reports that list all records for each table (about 13 tables in all), but when I encounter a field that I have utilized the "Lookup" dialog box (at the bottom left of the table design screen) with the following adjustments:

Display control - List Box
Row Source Type - Value list
Row Source - (my list- in this case "Kv","Blum"...)

I find that the entire list for the "Lookup" is shown for each and every record. How can I avoid this?

Dennis

Edited by: dandrew on Mon Jun 11 15:51:43 EDT 2007.
Go to the top of the page
 
+
MattJ
post Jun 11 2007, 02:49 PM
Post #2

UtterAccess VIP
Posts: 4,621
From: North Carolina, USA
Don't use lookup's in the table! See here .

HTH
Matt
Go to the top of the page
 
+
dandrew
post Jun 11 2007, 02:57 PM
Post #3

UtterAccess Member
Posts: 20
From: Orange County, Ca
Matti,

That's for the lit. I'll see about trying to eliminate "lookups"
Go to the top of the page
 
+
« Next Oldest · Access Reports · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th June 2013 - 11:19 PM