no definition for fonction error 1

[Xenocide]

Hi

strSQL1 = "UPDATE [" & Me!lst1.Column(0) & "]
SET MontantActuel = txt1.Value
WHERE IdEngagementA = lst1.Column(1)"

it create an error about a no definition for lst1.Column (the last one)

somebody know what it is?

 

[RoyVidar]

If this is on one line, I suppose

[tt]strSQL1 = "UPDATE [" & Me!lst1.Column(0) & "] SET MontantActuel = txt1.Value WHERE IdEngagementA = " & lst1.Column(1)[/tt]

If IdEngagementA is a text field, you'll need single quotes (text delimiters)

Roy-Vidar

 

[RoyVidar]

Oh, and concatenation goes also for the text control - and, single quotes should MontantActuel be a text field.

[tt]strSQL1 = "UPDATE [" & Me!lst1.Column(0) & "] SET MontantActuel = " & txt1.Value & " WHERE IdEngagementA = " & lst1.Column(1)[/tt]

Roy-Vidar

 

[Xenocide]

Thanks it's not doing the error anymore.. although it's updating 0 line in my table

I'll find what cause that eventually

htanks for the help again

 

[PHV]

WHERE IdEngagementA = '" & lst1.Column(1) & "'"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Xenocide]

Thanks for the help but someone was faster then you PHV

and if it's for the 0 line updated that's not it.. prally some other error.

I'll find it eventually

 

[PHV]

Have you solved your problem selecting IdEngagementA differently for each table ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Xenocide]

sorry for the big delay but I left work before yur message and I don't do anything work related after the hours

For the selecting of IdEngagement yeah it was solved. Redoing the table seem like it solved it all.