visual basic question to update a record with a form

[kmw]

This is what I have in the expression builder in Visual Basic. Is there a problem with this? My query works when I use it manually but not when the button from my form accesses it. Is there an issue with the order of my basic code. I also used to have a "set warnings to false" line but I took that out to see if I would even get a warning and I don't. Any ideas on where the problem could be?

Thanks!

Option Compare Database

Private Sub CommandBacktoListBox_Click()


DoCmd.OpenQuery "UPDATEALL"



DoCmd.Requery

DoCmd.Close acForm, "FormUPDATEFROMLISTBOX"

DoCmd.OpenForm "FormViewListBox"


End Sub

[pbaldy]

Is the code running at all (do the forms open/close)? If not, make sure the db is in a trusted location or that you've enabled code.

[Missinglinq]

DoCmd.OpenQuery "UPDATEALL"

This should simply display your Query named UPDATEALL.

DoCmd.Requery

This line Requeries the Form that it resides in.

DoCmd.Close acForm, "FormUPDATEFROMLISTBOX"

This closes the Form named FormUPDATEFROMLISTBOX. Is this
the Form that this code resides in?

DoCmd.OpenForm "FormViewListBox"

This opens another Form.

*************

What, exactly, do you expect this code to do?

What does any of it have to do with the title of your thread "visual basic question to update a record with a form?" There's nothing here related to doing anything with a Record.

Linq ;0)>

[pbaldy]

My suspicion is that a query named "UPDATEALL" is probably an update query. One that updates one or more records.