new record at top

  • Thread starter Thread starter bindurajeesh
  • Start date Start date
B

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?
 
bindurajeesh said:
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?
Click to expand...


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.
 
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.
 
(re-posting, as I don't see my original reply)

bindurajeesh said:
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?
Click to expand...

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?
 
Back
Top