Applying VBA on subform fields?

[rodvaN]

Hello there, Im trying to apply vba into data on the subform, for example

Private Sub subform_Click()
Me.chkbox.Value = 0
Me.data.Value = ""
Me.Refresh
Subform2.Refresh

End Sub


I dont know it wont work.. It is for creating an automatic adder from subform to form, checking and adding data into it.
Anyone that could guide me ?
Thanks alot

 

[SOS]

Perhaps this would be a good starting point.

 

[rodvaN]

I already read that, still dont know what to do, sorry Im newbie in VBA..
Just need to uncheck the chkbox when I click on the whole line :S
And erase the column value from data

 

[SOS]

If the code is ON the subform in question you would just use:

Me.chkbox.Value = False
Me.data.Value = ""
Me.Requery

If the code is on the main form then

With Me.YourSubformContainerNameHere.Form
    .chkbox.Value = False
    .data.Value = ""
    .Requery
End With

Not really sure what parts you have on your main form and what on your subform and what they have to do with each other. Your description is, for a lack of a better term, lacking.

 

[gemma-the-husky]

can you explain what you are trying to do again

you have a main form and a continuous subform?

you want to get a total from the subform?

or something else?

 

[rodvaN]

This is what Im trying to do..
http://img188.imageshack.us/img188/2599/salidasform.jpg
That way I can add shipments into the number of the shipment..
But I just want to click the items so they add automatically with the shipment number on the textfield and automark ON, that would move it to the right side box.
http://img189.imageshack.us/img189/2787/codigorightform.jpg
I got that code on the subform_click
Still doesnt work.. :S
How can I achieve this?
S.O.S

 

[rodvaN]

still breaking my head to figure out something friendly and intuitive.

 

[SOS]

I can't view the pics until I go home. ImageShack is blocked at work.

 

[rodvaN]

Dang.. ill make it up to fix it, do you have Yahoo Messenger or MSN messenger?.. would really appreciatte dedicated help, I can pay via paypal ..