how to load blank record

[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

 

[Guest]

Hi Mo

Ensure the form is bound to a table or query and set the DataEntry to = Yes.

This will create a new record after you have entered data onto the form -
you really need an Add button.

 

[Guest]

sorry - typo

You "don't" really need Add button.

 

[Guest]

Wayne,

thanks for your reply,

i am able to enter data onto my form.
i have created an add button & it works ok adding new records.

the problem is when i load the form, it does not open a blank record, it
loads the first record on the table.

thanks

Mo

 

[Guest]

Wayne,

thanks for your reply, the problem is when loading the form, it does not
open a new blank record, it always loads the first record.

entering data onto thye record is ok,

thanks

mo

 

[Guest]

Wayne,

thanks for your reply, the problem is when loading the form, it does not
open a new blank record, it always loads the first record.

entering data onto thye record is ok,

thanks

mo

 

[Guest]

Wayne,

thanks for your reply, the problem is when loading the form, it does not
open a new blank record, it always loads the first record.

entering data onto thye record is ok,

thanks

mo

 

[Guest]

Hi Mo

Open the form in desing view and right click the area outside the detail
section (normally the grey area out side the form).

Open the properties box and in the Data column set the Data Entry to = Yes

This will open the form to a new record each time the form is opened.

Or open the form in design view and open the tool box and use the wizard to
add a button that will creat a new record - this has the benefit of adding
the new record option but still allowing you to view other records (which you
can't do in DataEntry mode)

 

[Guest]

Hi Mo,

If Wayne's advice isn't what you are after, you could simply have an On Open
event on your form using

docmd.GoToRecord acDataForm, me.Name, acNewRec

to move to a new blank record when you open it. This method still leaves
the other records available to you on your form.

Hope this helps.

Damian.

 

[Guest]

Damian,

spot on, thanks very much for the reply, this advised has worked without any
problems.
Thank you to both of you.

Waynes, one
somehow, it removed all the records & it opened the d/base with only 1 blank
record.

 

[Guest]

Wayne,

Thanks very much for the reply, somehow, after setting the Data Entry = Yes,
it removed all the records & it opened the d/base with only 1 blank record.

i have tried Damian advice & it worked fine.

 

[John Vinson]

Thanks very much for the reply, somehow, after setting the Data Entry = Yes,
it removed all the records & it opened the d/base with only 1 blank record.

No, it didn't.

DataEntry mode is designed to do exactly this. The records are there
in your table, just not displayed on the form. If DataEntry is on, you
can only SEE those records that you have entered since you opened the
form - preexisting records are concealed from view.

John W. Vinson[MVP]

 

[Guest]

John,

thanks for clarifing this point, now i know, i will keep this in mind for
future references.

Regards,

Mo