DLookUp not working in the event statment

[angie]

I am usingthis event after change on a combo box. I am trying to use the DLookUp because the proposaldescriptiong wasbeing cut off and not everything was showing in the field.


But I am getthe error : syntax error (missing operator) in query expression systemID=2ton 15 seer single. If I delete theme.propsaldescription line everything works great but I need it to fill thisalso on change.


Private Sub System_Change()
Me.Ton =Me.System.Column(2)
Me.Seer =Me.System.Column(3)
Me.HPModel =Me.System.Column(4)
Me.FuranceModel= Me.System.Column(5)
Me.CoilModel= Me.System.Column(6)
Me.HeaterKitModel= Me.System.Column(7)
Me.HeaterKW= Me.System.Column(8)
Me.TXVModel= Me.System.Column(9)
Me.ThermostatModel= Me.System.Column(10)
Me.SystemDescription= Me.System.Column(11)
Me.FinancedPrice= Me.System.Column(13)
Me.EstPayments= Me.System.Column(14)
Me.CashPrice= Me.System.Column(15)
Me.ProposalDescription= DLookup("proposaldescription", "[proposal query]","systemid=" & Me.System.Column(1))


SELECTSystems.SystemID, [Systems]![Ton] & " TON " & [Systems]![Seer] & "SEER " & [Systems]![Stage] ASSystem, Systems.Ton, Systems.Seer, Systems.HPModel, Systems.FuranceModel,Systems.CoilModel, Systems.HeaterKitModel, Systems.HeaterKW, Systems.TXVModel,Systems.ThermostatModel, Systems.SystemDescription, Systems.ProposalDescription,Systems.FinancedPrice, Systems.EstPayments, Systems.CashPrice
FROMSystems;

[isladogs]

If the systemid is a text field, you need text delimiters

"systemid='" & me.system.column(1) & "'"

but why is the field being truncated. is it a memo field? Are you using formatting like @ on the field?

[angie]

Its a memo field
Where do I put the above code?

[Gicu]

I would suggest moving the code to the AfterUpdate event of the combo box as the Change event triggers for every keystroke. I take it you know the Column property is zero-based -so if you want the first column is System.Column(0).

Cheers,
Vlad

[isladogs]

Use that code in your Dlookup line
Or fix the truncation issue and use the appropriate column of your combo.

Agree with gicu. Move code to after update event

[angie]

Thank you, I did as you said and moved it to after update event and corrected the code and it works great thank you again