Continuous Subform Question

[DisenoDigitalGroup]

I have a form that's used in a Utility Billing application for a property
management company. The main form allows the user to enter an Account Number
and then displays the name of the property (for verification) from one table
and a "list" of utility meters matching that account number in a continuous
subform. The subform includes several unbound data entry fields for
collecting the service date, usage and charge associated with each meter.
Once the user has "filled in" the subform, they click a "Post" button to
append the data to a utility bill detail file. I have everything on the form
working except the most important part - the output. My question is how can I
step through the rows shown in the continuous subform and retrieve the data
entered by the user?

 

[Jeanette Cunningham]

Hi DisenoDigitalGroup,
With an unbound form in continuous view, I don't see how you can enter more
than one record. I tried it and there seems to be no way to force an unbound
continuous form to be able to accept more than a single record.
Maybe your form has many different unbound controls for a single record?


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[DisenoDigitalGroup via AccessMonster.com]

I believe you're correct! I had the same result, so I've gone to Plan 'B' -
after the user enters the key value in the main form I'll execute a MakeTable
query and base my subform on that. I'll also add a 'Post' button that will
append the completed subform records in the temporary table to the 'live'
detail table.

Hi DisenoDigitalGroup,
With an unbound form in continuous view, I don't see how you can enter more
than one record. I tried it and there seems to be no way to force an unbound
continuous form to be able to accept more than a single record.
Maybe your form has many different unbound controls for a single record?

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

I have a form that's used in a Utility Billing application for a property
management company. The main form allows the user to enter an Account

[quoted text clipped - 13 lines]

data
entered by the user?