I have a combo box which is lists all my Products from another table, "Products", it just lists the names but i want it to when i select one, to take the value "weight" from that one record and put the weight in my textbox beside the product name, i need this as it will help calculate freight and etc..
this is a general idea of what ive been trying so far, ive tried using queries, reports... i just cant get it...
here is the code im trying..
Combo874 being where product names are listed and Text1144 being where i want the weight to go. the weight from prooducts form is just a number no kgs or tonne after it
Private Sub Combo874_AfterUpdate()
Dim p1 As String 'p1 as i have 4 product boxes and hence w1
Dim w1 As Integer
Me.Text = p1
Query Form_Products.[Product Name].Value
If Form_Products.[Product Name].Value = p1 Then
Query Form_Products.Weight = w1
Text1144.Value = w1
Please guys you help would be much appreciated!! Thanks!!