Editing a value but its not saving???

[mikehextall]

Hi guys I hope someone can help me, I have a list of products that I display in a listbox, when I double click a product its details display in the appropriate text boxes for me to edit but when I edit the value in the text box it does not change in the listbox, why is this?

Thanks in advance

 

[jdraw]

Do some research on requery. It would appear that the Listbox is populated, then you change a control on the Form ; you must requery the values to be displayed in the Listbox.

 

[mikehextall]

Do some research on requery. It would appear that the Listbox is populated, then you change a control on the Form ; you must requery the values to be displayed in the Listbox.

I have tried me.list.requery after the textbox update but nothing happens

 

[vbaInet]

1. Your textbox needs to be bound to the field.
2. The value needs to be force saved.
3. The listbox needs to be requeried.

That's the order of events.

 

[mikehextall]

1. Your textbox needs to be bound to the field.
2. The value needs to be force saved.
3. The listbox needs to be requeried.

That's the order of events.

Bound and re queried I can do, force saved im not so sure?

 

[vbaInet]

DoCmd.RunCommand acCmdSaveRecord

Or

If Me.Dirty Then Me.Dirty = False

I prefer number 1.

 

[mikehextall]

DoCmd.RunCommand acCmdSaveRecord

Or

If Me.Dirty Then Me.Dirty = False

I prefer number 1.

Ok im making progress, I can save and requery but it doesnt alter the record i selected from the list it changes the next entry above it leaving the old entry unchanged and the new entry below???

 

[vbaInet]

It will save the current record, old or new. If you want to save just an individual piece of data then you need to fire an UPDATE query.

 

[mikehextall]

How do I do that?

 

[vbaInet]

Do you know how to create update queries?

 

[mikehextall]

Do you know how to create update queries?

No sorry!?

 

[vbaInet]

Right, that's something you need to read up.

http://office.microsoft.com/en-us/access-help/update-data-by-using-a-query-HA010076527.aspx

Once you have the query working using static conditions, we can move to the next step.