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

[Mhouser]

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

 

[OBP]

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?

 

[Mhouser]

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.

 

[Mhouser]

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