1) I have a form with listbox (query sourced), results are filtered on search.
2) Click on any record in lisbox, populates form data, on ID (ID_ArticleDetails) match basis.
3) form has two comboboxes, which are autopopulated as of point 2.
4) these comboboxes have bound column of ID, while user can see text.
5) user can select data from these comboboxes to change the record. Basically IDs (foriegn IDs) will be updated.
If too complex, ignore above,
What I want,-- on click button
I want to update another two other fields in table based on ID_ArticleDetails on the form as well as in table being updated
button has following code, and gives me error 3048
I feel that there are some comma, conjuntion errors. I could not figure out.
2) Click on any record in lisbox, populates form data, on ID (ID_ArticleDetails) match basis.
3) form has two comboboxes, which are autopopulated as of point 2.
4) these comboboxes have bound column of ID, while user can see text.
5) user can select data from these comboboxes to change the record. Basically IDs (foriegn IDs) will be updated.
If too complex, ignore above,
What I want,-- on click button
I want to update another two other fields in table based on ID_ArticleDetails on the form as well as in table being updated
button has following code, and gives me error 3048
I feel that there are some comma, conjuntion errors. I could not figure out.
Code:
Private Sub btnUpdate_Click()
Dim DetailsID As Integer
DetailsID = Me.ID_ArticleDetails
CurrentDb.Execute "UPDATE MainOrdersEntries SET ID_Article = Me.ID_Article" & ID_Company = Me.ID_Company & _
" WHERE ID_ArticleDetails = DetailsID"
End Sub