ERROR:
Code:
Run-Time Error '3070': The Microsoft Office Access database engine does not recognize
'Forms]![frmChangeSeatAvailability]![txtCurApprovedSeats' as a valid field name or expression.
CODE:
Code:
Private Sub cmdSaveChanges_Click()
DoCmd.OpenQuery "aqryChangeSeatAvailability"
DoCmd.Close acForm, "frmChangeSeatAvailability"
Call Forms.frmMain.ClassInfoUpdate
End Sub
aqryChangeSeatAvailability SQL:
Code:
UPDATE tbl3ApprovedGrantClasses SET tbl3ApprovedGrantClasses.CurMaxApprovedSeats = [Forms]![frmChangeSeatAvailability]![txtCurApprovedSeats]
WHERE (((tbl3ApprovedGrantClasses.ApprovedClassID)=[Forms]![frmChangeSeatAvailability]![cboClassSelection]));
INFORMATION:
First off, thanks for the amazing help that I get here everytime I post. I greatly appreciate it. Today I was testing the functionality of my database, as it is nearly completed (minus the fact that a database is never truly completed because the end users want new ways to do things later).
Anyways, while stepping through all the different things that they can do and smoothing out wrinkles, I ran into one that just will not iron out for me. It has me stumped. What I am trying to do is have cmdSaveChanges initiate aqryChangeSeatAvailability that gets its data from frmChangeSeatAvailability.txtCurApprovedSeats and frmChangeSeatAvailability.cboClassSelection. However, I am getting the error shown in the title and at the top of this post.
Thank you again, for taking the time to review my problems, even though I am sure that you have enough problems of your own, as we all do. Looking forward to receiving ya'lls feedback!