pyromaniac
Registered User.
- Local time
- Yesterday, 23:21
- Joined
- Jun 26, 2015
- Messages
- 30
I had 3 drop down filters that worked when the word being filtered was written in the table. I have since then linked them to new tables to be more database-y. The problem I have found (a couple weeks later too) is that my drop downs broke.
It makes sense why, they are now 1,2,3,4 instead of words but how do I make this work now that it isn't in the current table?
Sorry if this turns out obvious, I've been cleaning up peoples excel documents all day and my eyes are crossed.
-Thanks
****EDIT****
The words that were in MDS are now calling a table called MDS and a field called MDS (Again, sorry about that. didn't do good with the naming).
It makes sense why, they are now 1,2,3,4 instead of words but how do I make this work now that it isn't in the current table?
Code:
Private Sub cboMDS_AfterUpdate()
Dim myPlane As String
If Me.cboMDS = 0 Then
myPlane = "Select * from Baseline"
Else
myPlane = "Select * from Baseline where ([MDS] = " & Me.cboMDS & ")"
End If
Me.Baseline_subform.Form.RecordSource = myPlane
Me.Baseline_subform.Form.Requery
Me![cboType] = Null
Me![cboClass] = Null
End Sub
Sorry if this turns out obvious, I've been cleaning up peoples excel documents all day and my eyes are crossed.
-Thanks
****EDIT****
The words that were in MDS are now calling a table called MDS and a field called MDS (Again, sorry about that. didn't do good with the naming).
Last edited: