Thanks for the work around. I got it working with this coding.
Private Sub Water_AfterUpdate()
On Error Resume Next
WATCODE.RowSource = "Select watcodesF.WATCODE " & _
"FROM watcodesF " & _
"WHERE watcodesF.WATER = '" & Water.Value & "' " & _
"ORDER BY...
Let me start off by saying that I am very new to access. I actually just started last night to teach myself heuristically how to create a form for work. I have these two combo boxes; one is linked to a field of names of lakes of the state of Maine, the other is linked to a field of lake...