Complex Conditional DLookup/Query problem

M

Monet 138

Sorry if this posted twice, the post window screwed up so after checking the
forum for 15 min w/o it showing I'm typing this up again.

I'm still pretty much a newbie with all this so I'm hoping one of you
excellent people can help me make this work. Here is the setup.

tbl_Main: contains a field (num) named LOCATION which is linked via
relationship to tbl_Location
tbl_Location: contains many fields, AREA_1 (num), AREA_2 (num), STREET_1
(num), STREET_2 (num), COUNTY (num), PROJECT (text), MISC (text)
tbl_Loc_Area: contains Area (text) and Area_ID (num) which is linked via
relationships to both AREA_1 and AREA_2 in tbl_Location
tbl_Loc_Street: contains Street (text) and Street_ID (num) which is linked
via relationships to both STREET_1 and STREET_2 in tbl_Location
tbl_Loc_County: contains County (text) and County_ID (num) which is linked
to COUNTY in tbl_Location

What I want to do within an unbound text box on a form is display a complete
Location description using all the Text values and some other formating. Not
all fields for each entry in tbl_Location will contain information so I will
need probably need some sort of If Not IsNull conditional for each value.
Also the people at the office here want the text to display a particular way.

Example:
AREA_1 - AREA_2 / STREET_1 - STREET_2 / PROJECT / COUNTY / MISC

So instead of seeing
234 - <no area_2> / 123 - 654 / <no project> / 11 / Stream Crossing
it would show
Hamlin / Main Street - 2nd Avenue / Putnam / Stream Crossing

Thanks in advance for the help.
 
M

Monet 138

I finally realized I can place a second DLookup within the first at the
Criteria section. Seems so simple now.
 
Top