G
Guest
I have the following code in the afterupdate event of a field called actual
Pit. Once the pit is selected it shows only the cost and material from that
given pit.
Private Sub cboactpit_AfterUpdate()
Dim nsql As String
nsql = "Select Costperton,Material " & "FROM materialcostsheet " & "WHERE
pit=""" & Me.cboactpit & """ " & "ORDER BY material"
Me.cbocost.RowSource = nsql
End Sub
However - it functions and looks nice but not doing Exactly what I want it
to do
It display the costperton, than the material in the drop down obviously in
order by material
Don't know if this is possible but I would like the user to type in the
material Name and it to scroll to the given material - BUT THE COSTPERTON
SHOULD BE STORED IN THE FIELD - One is text the other number field not sure
what i need to do or if this is possible.
Thanks,
Barb
Pit. Once the pit is selected it shows only the cost and material from that
given pit.
Private Sub cboactpit_AfterUpdate()
Dim nsql As String
nsql = "Select Costperton,Material " & "FROM materialcostsheet " & "WHERE
pit=""" & Me.cboactpit & """ " & "ORDER BY material"
Me.cbocost.RowSource = nsql
End Sub
However - it functions and looks nice but not doing Exactly what I want it
to do
It display the costperton, than the material in the drop down obviously in
order by material
Don't know if this is possible but I would like the user to type in the
material Name and it to scroll to the given material - BUT THE COSTPERTON
SHOULD BE STORED IN THE FIELD - One is text the other number field not sure
what i need to do or if this is possible.
Thanks,
Barb