UtterAccess Discussion Forums > Printing records of a table w/out listing all of the all Values

Full Version: Printing records of a table w/out listing all of the all Values

UtterAccess Discussion Forums > Microsoft® Access > Access Reports

dandrew

Jun 11 2007, 02:46 PM

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.

MattJ

Jun 11 2007, 02:49 PM

Don't use lookup's in the table! See here .

HTH
Matt

dandrew

Jun 11 2007, 02:57 PM

Matti,

That's for the lit. I'll see about trying to eliminate "lookups"

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.