Field column value problem PLEASE HELP!

[Jar80]

I have form that contains subform which view is Datasheet, so here is the problem.

I want that when i press field in the subform then it change the value in that column to 0 from all fields that are below the field i press.

 

[KenReay]

Hi

Say you can recognise the row on which the click occurs via the column LineItem, and say the column you want to zero is called Qty

in the onclick event of the control bound to Qty, something like:

With Parent.SubFormControlName.Form.RecordsetClone
If .RecordCount > 0 Then
.MoveFirst
Do Until .EOF
If !LineItem > Me.LineItem
!Qty = 0
End If
.MoveNext
Loop
End if
End With

should do the trick

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK