form-subform question

I can't figure out how to do create this screen. I think I need to use
a form with subForm(but I'm not sure).
Could you direct me to an article. Or give me some advice on how this
is done.

I have an apartment building. And I want to record the (tenant
payment) checks I put onto my bank deposit ticket.

I have 2 tables
1)
TablePaymentsReceived it has 3 fields
Date
TenantName
Amount
2)
TableTenantName it has 1 field
TenantName


I want to create a data entr=E9e form to populate the
TablePaymentsReceived table just as if
I would be filling out my bank deposit ticket.

The screen will have on top the Date, TenantName, Amount for all the
checks I am putting on the current deposit ticket (perhaps in
datasheet view).There will be no editing allow directly onto this top
part of the screen.

And on the bottom of the screen
There will be

A list box bound to TableTenantName(TenantName) from which I shall
select a TenantName

A text box in which I will enter the $amount paid by selected tenant.

A control button labeled "enter" when pressed the selected TenantName
and amount will be posted to the top of the screen

A control button labeled "apply all" when pressed the list of the
tenants with there payment amount will be applied to the
TablePaymentsReceived (so if 5 payment were recorded to the top part
of the screen then 5 new records will be added to
TablePaymentsReceived)

A control button labeled "cancel all" witch will clear the screen



Thanks Steven Green

Re: form-subform question

Sorry - totally wrong

Table Tennants - TennanantID (AutoNumber) TennantName (Text) and anything
else you want (phone, email etc)
Table Payments - PaymentID (AutoNumber) , TennanantID (Long), PayAmount
(Currency), PayDate (Date)

In your relationships, link the 2 TennantIDs and enforce referential
integrety. So you can't have a payment without a tennant.

Build a form based on Tennants
Build a continuous subform based on Payments

Link the form and subform using the TennantID

Select the tennant (Use a combo box), enter the payment (set the PaymentDate
default to Date() - saves you entering it)

Then you can either have a report showing a tennant and all the payments, or
a report showing payments made between certain dates and who made them

HTH

Phil


wrote in message
news:5be24a2a-cc55-4b52-9e37-2788b8d13036@a28g2000hsc.google groups.com...
I can't figure out how to do create this screen. I think I need to use
a form with subForm(but I'm not sure).
Could you direct me to an article. Or give me some advice on how this
is done.

I have an apartment building. And I want to record the (tenant
payment) checks I put onto my bank deposit ticket.

I have 2 tables
1)
TablePaymentsReceived it has 3 fields
Date
TenantName
Amount
2)
TableTenantName it has 1 field
TenantName


I want to create a data entrée form to populate the
TablePaymentsReceived table just as if
I would be filling out my bank deposit ticket.

The screen will have on top the Date, TenantName, Amount for all the
checks I am putting on the current deposit ticket (perhaps in
datasheet view).There will be no editing allow directly onto this top
part of the screen.

And on the bottom of the screen
There will be

A list box bound to TableTenantName(TenantName) from which I shall
select a TenantName

A text box in which I will enter the $amount paid by selected tenant.

A control button labeled "enter" when pressed the selected TenantName
and amount will be posted to the top of the screen

A control button labeled "apply all" when pressed the list of the
tenants with there payment amount will be applied to the
TablePaymentsReceived (so if 5 payment were recorded to the top part
of the screen then 5 new records will be added to
TablePaymentsReceived)

A control button labeled "cancel all" witch will clear the screen



Thanks Steven Green