Recent content by dawnthomas

After much gnashing of teeth and tearing of hair I got it. I moved all the detail controls into the header area and used =dlookup("name","Tenants","[tenantno]=1") and =dlookup("name","tenants","[tenantno]=2") and it worked!!!!! I really...

Thanks, Brian.&nbsp;&nbsp;Makes sense.&nbsp;&nbsp;Right now my tenant records contain gobs and gobs of data (birthdate, occupation, income, etc) besides just the apt number and tenant number.&nbsp;&nbsp;I use this for demographic info.<br><br>Is there a short and sweet way to create a table...

Tried it several ways and still have same problem.&nbsp;&nbsp;Lets make it simple.&nbsp;&nbsp;Here is information I...

Sorry.&nbsp;&nbsp;I am trying to print a report on a Lease Form that shows all the LeaseMaster information (Apartment#, Building, Rent rate, etc) in one section and then on one line I need to show tenant #1 and tenant #2 right next to it.&nbsp;&nbsp;When I try to put in an unbound field with...

I am very new to Access but enjoying the process!&nbsp;&nbsp;I have a property management database with a master form LeaseMaster with a subform Tenants.&nbsp;&nbsp;There can be anywhere from one to five Tenants to each LeaseMaster.&nbsp;&nbsp;They are identified by Apt# and then a numeric code...