DLookup Problem

[alsoto]

I have attached the following code to the on click event of a button on my main form:



Forms![frmChinsListSFA]![subformChinsListSFA].Form![Quantity] = DlookUp ("[Quantity]", "tblChinsListProcDefaults", "[ProcNo]=" & Forms![frmChinsListSFA]![subformChinsListSFA].Form![procNo] & " AND [ID]=" & Forms![frmChinsListSFA]![subformChinsListSFA].Form![ID])

The subform (record source is a table) has about 300 records. When I click the button, the update doesn't work except when I highlight a record. Then it updates only for that record and not for the other 299 records.

Can anybody please tell me why all the records are not updated?

Thanks,
Al

ps I tried hitting Ctrl + A to highlight all the records and then hit the button, but that did not work.

[RuralGuy]

Can't you achieve the result with a join in a query? If this did work, it would be painfully slow.

[alsoto]

So you think I would be better off using an update query?

Can't you achieve the result with a join in a query? If this did work, it would be painfully slow.

[RuralGuy]

If that is what you want to do, yes. I was suggesting a join but if you have an update scheme then use that.

[alsoto]

RG,

I used an update query as a solution, with form fields as parameters.

Thanks as always,
Al Soto

[RuralGuy]

You're welcome Al. Glad we could help.