how to load blank reocrd

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

Background,
I have created a small D/Base. Within the dbase, I have created a form with
text box.
The idea for the text box is for users to add a description of some sort,
then click on a ADD Button & new record is created.

Problem,
i would like to open up the dbase & go to a blank record rather go to the
first record.

Example,
I have 25 records in the dbase, when I open it I ought to go to record 26
which is a new blank record. Instead the dbase opens up in record number 1.

Any idea on how I can resolve this?

Thank you,

Mo
 
Hi

I would suggest having another form that opens when you start the
database, i.e. a switchboard. On this you could have a command button
for opening the form as it is now and another for opening the form to
add a new record.

So, to open as now:
DoCmd.OpenForm "formname"
and to open to add a new record
DoCmd.OpenForm "formname", acNormal, , , acFormAdd

James
 
James,

thanks for your reply.

James said:
Hi

I would suggest having another form that opens when you start the
database, i.e. a switchboard. On this you could have a command button
for opening the form as it is now and another for opening the form to
add a new record.

So, to open as now:
DoCmd.OpenForm "formname"
and to open to add a new record
DoCmd.OpenForm "formname", acNormal, , , acFormAdd

James
Click to expand...
 
Back
Top