How to enter a set of record to a unbound Subform.

[chwong]

I have create an unbound subform. I need to let user to
enter more than 1 record at the same time. Problem faced
is when the user enter the 1st record the rest of the
column will be display the 1st record information. Is
there any where to solve this problem? I do not want to
used bound subform because the conectivity between client
and server will be heavy. Please advice!
Thanks!

 

[Hugh O'Neill]

I have create an unbound subform. I need to let user to
enter more than 1 record at the same time. Problem faced
is when the user enter the 1st record the rest of the
column will be display the 1st record information. Is
there any where to solve this problem? I do not want to
used bound subform because the conectivity between client
and server will be heavy. Please advice!
Thanks!

You are apparently using an unbound continuous Form. The behaviour you
see is quite normal. It is because a continuous Form is just multiple
instances of the one row of controls. Therefore, if you type a value
into one control, all its instances will show that value.

If the contol or the form is bound to the record source, that will not
happen as each row will relate to a record and there will be an 'empty'
row at the bottom for new data entries (depending on your design).

Using a bound Form in this scenario should not suffer from network
traffic. In such a scenario you should have the front and back ends
split, so the tables only are on the server.

hth

Hugh