Hi, I'm new to Access and VBA. I have inherited a small project which has several Combo Boxes and I need to extract and complete the form with data from other tables dependent on the combo box selection. It is a very simple combo box table with 2 fields.
WireCode, WireDescription.
On the form is a combo box attached to the table wire.
On the selection of the WireCode I need it to update a field on the form fldWdgWireDesc, this is the code I have tried in lots of variations but I cannot get past the error "Invalid Outside Procedure"
This is the code.
Private Sub_WireCombo_AfterUpdate
[fldWdgWireDesc] = DLookup("[tblWire]![WireDescription]", "tblWire", "[Wirecode]=[fldWdgWire]")
Me.Refresh
endsub
Any help would be appreciated.