I Think I Am Cursed....

[lilmikey1982]

I've been picking my brain and losing sleep over this stupid issue, and now matter how hard I try, I can't seem to fix it. So again, I return to my WONDERFUL friends here at the Access Forum. :-D My problems is, I narrow down this list of photos by 3 keywords. But when I get to the third one, it wants a description, when all I want it to do is simply update the table. I'm VERY new to VB, and I've tried to fix it, but alas, to no avail. I have attached the file, and ANY help you may be able to provide, would be SO helpful. Thank you all for your help!!

 

[antomack]

The problem is in relation to the AfterUpdate of the third combo. You have it set up as if the entry from the combo would be numberic. It should read as follows, the bold highlights what is needed extra.

Private Sub cboNumericField_AfterUpdate()

Dim strSQLSF As String

strSQLSF = " SELECT * FROM tblDemo "
strSQLSF = strSQLSF & " WHERE tblDemo.RowField = '" & cboRowField & "' And "
strSQLSF = strSQLSF & " tblDemo.ColumnField = '" & cboColumnField & "' And "
strSQLSF = strSQLSF & " tblDemo.NumericField = '" & cboNumericField & "'"


Me!sfrmForm.LinkChildFields = ""
Me!sfrmForm.LinkMasterFields = ""

Me!sfrmForm.LinkChildFields = "RowField;ColumnField;NumericField"
Me!sfrmForm.LinkMasterFields = "RowField;ColumnField;NumericField"
Me.RecordSource = strSQLSF
Me.Requery

End Sub

 

[lilmikey1982]

I knew it had to be something like that! THANK YOU SO MUCH!!! That was the problem right there!