Fields Won't populate

[Whitey]

I have tblTenantInfo related to tblRentPayments as a one to many on UnitID
field. The form I created to enter rent payments has FirstName and LastName
fields from tblTenantInfo on it and when I enter a unit # in UnitID field of
tblRentInfo the first and last Names show up automatically from
tblTenantInfo, which is what I want so I have a visual check that the rent is

going to the correct tenant.
Problem - I created another form to enter and update current rent amount. I
have tblTenantInfo related to tblLeaseCharges as a one to one on UnitID
field. Obviously, each tenant only has one rent amount but the rent can
increase. When I enter a unit # in UnitID field of tblLeaseCharges the
related first and last name fields from tblTenantInfo remain blank. How can I

get the First and Last fields to show up automatically like they due in the
1st form I created?

Thanks for any reply - I am a self taught novice.

 

[tina]

also posted this date in microsoft.public.access.forms under Subject:
Adding Record in form - Related Data from related tbl doesn't show.

please don't multipost. for more information, see
http://home.att.net/~california.db/tips.html#aTip10.

hth

 

[Whitey via AccessMonster.com]

Yes - sorry It wasn't intentional. I am new to Monster and had posted this on
Microsoft Disscussion Groups not knowing it would post on Monster as well.

also posted this date in microsoft.public.access.forms under Subject:
Adding Record in form - Related Data from related tbl doesn't show.

please don't multipost. for more information, see
http://home.att.net/~california.db/tips.html#aTip10.

hth

I have tblTenantInfo related to tblRentPayments as a one to many on UnitID
field. The form I created to enter rent payments has FirstName and LastName

[quoted text clipped - 13 lines]

Thanks for any reply - I am a self taught novice.