Records not saving in forms

[Neilster]

Hi guys

I have a main form which has a button that opens another form to a specific record which is fine. However when the second form opens and i enter data into the feilds then close the form, now for some reason it stops saving the entered data???

The form is set to the same table as the first form and all fields are bound.

I've tried everything for nearly a week now and I can't fix it.

Can anyone shed some light on this. thanks :banghead:

 

[apr pillai]

New record is automatically saved when you advance to the next/previous record. You may save the record by pressing Ctrl+S keys before closing the Form.

 

[ct2013]

Are you using a query based form??!?!?

If that is the case a lot of times when you open a form from another form on a query it will just be looking up the data hence may not allow you to edit data.

Also check in the property sheet in the form that under the tab "data" the locked is set to "no". Whilst you are there in the property sheet just check that the control sauce and row sauce is all set right.

If none of this helps try creating another test from and see if it allows you to update/change data then you can start seeing whether it is a form problem or your whole database.

Good luck

 

[Neilster]

Thats the point I'm trying make, new records don't save automaticlly as they did previously. Therefore why has it decided to not save new data entery?

And no CT_ it's linked to a table and all fields are bound

 

[ct2013]

check that the command is acEdit and not acAdd!

 

[jdraw]

Can you post a database with enough data etc to show the situation? remove anything private/confidential. We don't need real data.

 

[Neilster]

Where do i look for the acEdit?

 

[ct2013]

send me the code of the button used to open the second form

 

[Neilster]

This is what I have on a click button on the main for to open the 2nd form

DoCmd.OpenForm "Frm2ndContact", , , CompanyName = "'" & Replace(Me.CompanyName, "'", "''")

 

[ct2013]

can you send a copy of your db?
I usually place acnormal and acedit but would need to have a try on yours as it ios a replace and i dont usually have such forms.

 

[ct2013]

DoCmd.OpenForm "Frm2ndContact", acNormal, , CompanyName = "'" & Replace(Me.CompanyName, "'", "''")

Try this maybe

 

[Neilster]

ct tried the code above and no different, If i start over again building the DB it works fine, however I don't want to do that

 

[Neilster]

Its being saved to the table but not visable in the form anymore?