Form always opens on a New record

[reburton]

I have a form that I built with the intention of creating new records. I want to convert it to use with existing records too. I can't seem to get it to look at anything but new records. I imagine it is a property setting and something very minor to a seasoned Access programmer, but it has me thoroughly confused.

 

[pbaldy]

Check its Data Entry property.

 

[reburton]

Thanks for replying! I had thought of that myself and I just double-checked it. Sadly, it is set to yes. But thanks!

 

[pbaldy]

You want No.

 

[reburton]

Thanks! That did the trick. I would have never thought to change that.

 

[pbaldy]

No problem.

 

[reburton]

Now I have the opposite problem. I have a command button to open a new record that doesn't work anymore. The lineI used to open a new record is :
DoCmd.GoToRecord , "", acNewRec
It doesn't give me an error message or anything it just doesn't work.

 

[pbaldy]

Is any code running? In later version of Access, the db must be in a trusted location for code to run, or you have to explicitly enable it.

 

[reburton]

Nothing running that I know of. I just have my form open and nothing else going on in Access.
There is one thing that might provide a hint. If I click on my new record button nothing appears to happen, but if I click on my save button I get an error message saying there is no current record. I tried refreshing the record but it still appears to be unmoved.

 

[pbaldy]

Sorry, I meant is code able to run in the db at all.

 

[reburton]

Yes most everything else runs fine. There are a few things in progress but code seems to run okay.

 

[pbaldy]

Then I don't see anything wrong with that code. Does the form allow new records?

 

[pbaldy]

Can you post the db here?

 

[reburton]

I figured it out! I shouldn't feel so happy, since I caused the problem myself. The Record Source query for the invoice form was left as a totals query after some experimenting I did a few days ago. I changed it back to a select query and everything works fine. Thanks for bearing with me as I stumble through learning Access. :banghead:

 

[pbaldy]

Glad you sorted it out. That would do it, as a totals query is read only.

 

[reburton]

Yeah, I'm a real knucklehead at times, but I am persistent. Thanks again!
.

 

[pbaldy]

Yeah, I'm a real knucklehead at times, but I am persistent
.

That describes me too.