Help with access form (insert table value into form field)

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

 

Mhouser, if you are trying to "display" a value related to the Combo selection you can have thta value as an extra column in the combo and refer to it with simple VBA.
You should not populate a Field's actual value with that from the combo as that is duplication.
Can you tell me which one you are trying to do?

 

This is close to what I want to happen.

Me.Equipment_Type =DLookup("EquipmentType","Equipment","Equipment = " & Me.Equipment)

But this returns a Null Value

I'll do as you suggest and place both columns into the combo box.

 

Don't know how this works. It's doing exactly what I want when I place both columns in the combo box.

On Equipment field change event:
Me.Equipment_Type = Me.Equipment