Open form to new record, I can't find the form selector

[punter]

Hi,

I'm trying to get my forms to open to a new record. According to access help and various others sources of information I need to go to the form selector and set Data Entry to Yes.

The problem is I can't find the form selector. I have attached a copy of the database in case anyone wants to look at it. Am I just nuts (strong chance) and I can't see it?

The form I was looking at is called BOL Information.

Thanks

Eddie.

 

[GaryPanic]

First of all -is this what you really want
everytime you open a form - it will write a new record
you may just want to view data -

 

[punter]

I want the BOL information form to a form where only data entry takes place. After I enter a few records, close the form, and reopen it the older records are there. When I open the form I want it to be blank and ready for entry of the next record.

Thanks

Eddie.

 

[missinglinq]

You need to go to the form's Property Box, not Form Selector (whatever that is) and set Data Entry to Yes.

From the form's Design View:

In the left upper corner of the form, just under its title bar, you'll see a small square which should have a smaller solid black square inside it. Right click on this and click on Properties. The Properties Box should popup with Form listed at the top. Click on the Data TAb and set Allow Editions to Yes and Data Entry to Yes. The form will now open ready to have new records entered.

The problem with setting the form up like this is that it will always open only for adding records. You'll never be able to view the "old records" as you call them from this form. You can copy your form, then go into the copy's Property box and set Data Entry to No, and use this new form to view your records. There are other ways of handling this, but this is the only way to handle it in the manner you've described.

 

[punter]

Thank you so much for your reply.

I'm glad to see that it will work. However, if there is a better way I'm all open to it. If you were me and you were setting a form to enter data off of what would you to make sure that someone wasn't scrolling back and screwing up any old data? I am more than open to any suggestions and ideas.

Thank you always for the help.

Eddie.

 

[punter]

Thank you so much missinglinq. That worked.

Eddie.

 

[missinglinq]

That's why we're here!

Have a great weekend!

 

[Suepoo]

Using VB...

Hi, this is my first time here. I hope I can be of help. I wanted to do exactly the same thing. I have an opening form where I created buttons that opens up the forms straight to a new record. This way it is only the button that does this while the form itself (if opened from the file list or another button) still opens as normal. Does this make sense? Probably not very good at explaining it.

When I create the button and am happy with it I then went to properties. Under the event tab I go to "On Click" and select code builder. The following is what I have so that when the button is clicked it takes me straight to a new record....

Private Sub new_alpaca_Click()
On Error GoTo Err_new_alpaca_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "alpaca_main"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.GoToRecord , , acNewRec

Exit_new_alpaca_Click:
Exit Sub

Err_new_alpaca_Click:
MsgBox Err.description
Resume Exit_new_alpaca_Click

End Sub


I hope this helps a little