Hello all,

Thank you for the videos. I use them for both memory refreshers and learning new concepts all the time.

Now to my question: I've designed a form with an update query, and have linked the qry fields to the form, but when I click on my update button, nothing happens (sql is below). The text boxes on my form match each of the fields in my query, but no update.

SQL: UPDATE tblSong SET tblSong.CurPresented = [Forms]![frmSongUpdate]![txtNewCurrent], tblSong.PrevPresented = [Forms]![frmSongUpdate]![txtNewPrevious], tblSong.[Position] = [Forms]![frmSongUpdate]![cmbNewPosition], tblSong.Active = [Forms]![frmSongUpdate]![cmbNewActive]
WHERE (((tblSong.CurPresented)=Forms!frmSongUpdate!txtExistingCurrent) And ((tblSong.PrevPresented)=Forms!frmSongUpdate!txtExistingPrevious) And ((tblSong.Position)=Forms!frmSongUpdate!cmbExistingPosition) And ((tblSong.Active)=Forms!frmSongUpdate!cmbExistingActive));

Along with these fields, I've included the title field in the form, but not in the query because that field is not being updated. Should I include the title as well?

Thx 4 the assistance. Keep up the good work.