record in form & table not updating when saved

[moises]

Hi guys,

When i save the new record that inserted is not updating in the table & form and also when click the cmdPreviousRec its escaping the inserted record.

Please can anyone help me.

Attaached file is the one i'm working:

[pbaldy]

The save button appears to be disabled. What is the result of the Debug.Print?

[moises]

Hi paul,

Actually there's no error when i save the new record, but it's not updating directly in the table & form. When i navigate thru my custom navigation button it is escaping the new record, i can see only the last previous record not the new inserted record in the table.

[moises]

I can see only the new inserted data when i cloase and reopen the form

[John_G]

You are saving the new record to the table using code; in order to see the new record on the form, you need to requery the form's recordsource (Me.requery), but note that when you do that, the form will reset to the "first" record - it won't automatically go to the last record you were on. You will need a bit of VBA to keep track of where you are.

[pbaldy]

What I meant was to use this technique:

BaldyWeb-Immediate window

I can't see how the data could be there after closing the form, since the textboxes are unbound. I closed it and there was no data in the table.

[moises]

Hi john,

You're right john the me.requery is not updating automatically. I need to close and re-open the form to see the new inserted data.

How could i fix this issue?

[moises]

Hi paul,

The debug.print shows the data is inserted into table.

[pbaldy]

The debug.print shows the data is inserted into table.

No, it shows SQL that may or may not be valid. Can't tell from a picture, and in my test it was bad.

[moises]

Hi guys,

I have solved my problem...

I forgot to add the code rs.addnew

Thanks a lot...

Merry Christmas