new record at top

[bindurajeesh]

I have a continuous form which allows additions and would like the new record
input area to be at the top of the form instead of the bottom. How can this
be done?

 

[Dirk Goldgar]

I have a continuous form which allows additions and would like the new
record
input area to be at the top of the form instead of the bottom. How can
this
be done?

You can only do this by means of subforms. For example, you could have an
unbound main form with two subforms: one on top in data entry mode, with
room for a single record, and a larger one on the bottom that has room to
display multiple records and doesn't allow additions. There would be code
in the AfterUpdate event of the top subform to move to a new record and
requery the bottom subform.

 

[bindurajeesh]

ok i have my unbound form with my two subforms. When I open the form with
the subforms the top subform which is the data entry form shows nothing. I
have the txt boxes bound to fields in the table i want to add records to. Do
I have to have those unbound as well and then do an insert into with a
command button? Thank you.

 

[Dirk Goldgar]

(re-posting, as I don't see my original reply)

ok i have my unbound form with my two subforms. When I open the form with
the subforms the top subform which is the data entry form shows nothing.
I
have the txt boxes bound to fields in the table i want to add records to.
Do
I have to have those unbound as well and then do an insert into with a
command button?

The top subform is for data entry, so it *should* show nothing. That is, it
should show you a blank record ready to fill in. That was what you wanted,
wasn't it?