Any Unbound Continuous Form Example Available

[accessNator]

I am trying to create a form where the USER adds a record but it also keeps a running total. Basically its a check deposit input form.

My form is a continuous form so the User can input multiple records at a time.

My first field is a drop down box where a user selects a company name (Combo box),
My second field is the user select Type Of Deposit (Combo Box)
My Third field is a Check No (Text Box).
My 4th field is an AMT (Text Box)

I need a validation check that if any of those fields are empty it cannot proceed to add another record or if a USER clicks on the SUBMIT button it checks to see if all those fields has an entry.

Any examples I can take a look at?

Thanks In Advance.

 

[PNGBill]

This may be better done with a main Form (Single Form) and Sub Form (continuous).

Just about impossible to have an unbound continuous form as the definition of unbound implies No Data.
You can enter data but only one record at a time so why have the form continuous unless you wish to display historical data in which case, it must have bound controls.

With the combination Main form, Sub Form you get the best of both worlds and can have as many unbound calculated controls on the main form and subform header and footer, as you like to Balance and Validate your data.

 

[accessNator]

This may be better done with a main Form (Single Form) and Sub Form (continuous).

Just about impossible to have an unbound continuous form as the definition of unbound implies No Data.
You can enter data but only one record at a time so why have the form continuous unless you wish to display historical data in which case, it must have bound controls.

With the combination Main form, Sub Form you get the best of both worlds and can have as many unbound calculated controls on the main form and subform header and footer, as you like to Balance and Validate your data.

PNGBill, You are correct. I erred on my post. Do you have such an example that I can look at?

 

[gemma-the-husky]

you cant do this with an unbound form, i dont think. You have to have the previous rows saved somewhere - if you see what I mean.

what you possibly want is to use a temporary table to input a batch of data. When the batch is completed then process the batch, by appending the new data to the real tables.

This idea may give you the control you need

 

[accessNator]

you cant do this with an unbound form, i dont think. You have to have the previous rows saved somewhere - if you see what I mean.

what you possibly want is to use a temporary table to input a batch of data. When the batch is completed then process the batch, by appending the new data to the real tables.

This idea may give you the control you need

gemma-the-husky, That is exactly the scenario I need.

What do I need to do to make sure BEFORE the USER can enter the next row of data, the current row meets all the validation requirements whether the required selection must be made in an combo box, tex tbox or any other input controls?

Any example of this scenario?

Thanks.