Here is what I'm trying to do.
For lists Equipment in drop down box.
Whatever equipment that is select, the equipment type field needs to be updated from a table.
Is there a way to get a value from SQL statement?
SQL = "SELECT [Equipment Type] FROM OrderDetails Where " _
& " Equipment = '" & Me.Equipment & "'"
[Forms]![OrderDetails]![Equipment Type] = SQL
For lists Equipment in drop down box.
Whatever equipment that is select, the equipment type field needs to be updated from a table.
Is there a way to get a value from SQL statement?
SQL = "SELECT [Equipment Type] FROM OrderDetails Where " _
& " Equipment = '" & Me.Equipment & "'"
[Forms]![OrderDetails]![Equipment Type] = SQL