Forms

[dinadvani via AccessMonster.com]

Hi,

I need your help to build in a form.

I want to build in a form so that it provides mulitple boxes for the reveune
amount and then total amount.

It should include text boxes for revenue where a user enters reveue for a
particular record.

A user can enter amount in Revenue 1, Revenue 2 etc.... But its not sure
whether a record will have 1 revnue entry sometimes the whole revenue related
to 1 record comes a single way and then there are no part payments so only
revenue 1 will be filled in. In some case it would be revenue 2 or 3 as the
case may be.

I hope I am not confusing the reader of this query too much but please excuse
me I am myself confused a bit.

Thanks for your help

Regards,
DA

 

[Guest]

You are somewhat confused since your Subject states "Forms", you posted in a
"Report" news group, and you should have posted in a tables design news
group.

You should not have multiple revenue fields. You should have multiple
revenue records in a related table.

 

[dinadvani via AccessMonster.com]

Thanks for your reply.

But I am not able to get what you are trying to say.

I think I was not that clear in my querry. Below are the details.

I have a form in which I have built a subform so that I can enter the part
payment amount in that subform for the registrations. Eveything on that form
is working properly I am able to enter the part amounts in subform and the
totals are proper. But if this subform has more than 1 entry then the next
form reflects the subform entry again. That means if I have total of 10
entries and of these 10 entries 1 form has 2 part payments and another form
has 3 part payment entries then the total entries in form shows 10+2+3

I don't want the subform details to get repeated again....Please help

Thanks,
D

You are somewhat confused since your Subject states "Forms", you posted in a
"Report" news group, and you should have posted in a tables design news
group.

You should not have multiple revenue fields. You should have multiple
revenue records in a related table.

Hi,

[quoted text clipped - 19 lines]

Regards,
DA

 

[Guest]

Since this is a "report" news group, I would expect to see a mention of
"report" in your message. If you are attempting to create a report, we need
to know something about your tables and records (not mentioned in your
message) and how you want them to appear on your report.
--
Duane Hookom
Microsoft Access MVP

Thanks for your reply.

But I am not able to get what you are trying to say.

I think I was not that clear in my querry. Below are the details.

I have a form in which I have built a subform so that I can enter the part
payment amount in that subform for the registrations. Eveything on that form
is working properly I am able to enter the part amounts in subform and the
totals are proper. But if this subform has more than 1 entry then the next
form reflects the subform entry again. That means if I have total of 10
entries and of these 10 entries 1 form has 2 part payments and another form
has 3 part payment entries then the total entries in form shows 10+2+3

I don't want the subform details to get repeated again....Please help

Thanks,
D

You are somewhat confused since your Subject states "Forms", you posted in a
"Report" news group, and you should have posted in a tables design news
group.

You should not have multiple revenue fields. You should have multiple
revenue records in a related table.

Hi,

[quoted text clipped - 19 lines]

Regards,
DA