K
kattkt
I have 2 combox boxes - one which updates the information displayed in the
next.
I have an After Update event set up:
Private Sub Press_AfterUpdate()
Dim sSQL As String
sSQL = "SELECT Product_Desc" _
& " FROM PartNumber WHERE Press1 = " & Me.Press _
& " ORDER BY Product_Desc"
Me.Part.RowSource = sSQL
Me.Part.Requery 'Requery the combo
End Sub
Note: PartNumber is a table not a query.
The problem is when entering information on the form - after the first combo
box is entered a parameter promt appears with a mathcing value to comboxbox1-
I must re-enter this information to get the correct items to appear in
combobox2.
I thought this above code should be querying the combox2 data without the
prompt?
next.
I have an After Update event set up:
Private Sub Press_AfterUpdate()
Dim sSQL As String
sSQL = "SELECT Product_Desc" _
& " FROM PartNumber WHERE Press1 = " & Me.Press _
& " ORDER BY Product_Desc"
Me.Part.RowSource = sSQL
Me.Part.Requery 'Requery the combo
End Sub
Note: PartNumber is a table not a query.
The problem is when entering information on the form - after the first combo
box is entered a parameter promt appears with a mathcing value to comboxbox1-
I must re-enter this information to get the correct items to appear in
combobox2.
I thought this above code should be querying the combox2 data without the
prompt?