Form_Click not responding

[kevink]

I have a sub that responds to a Form_click action on a datasheet form, however, the sub will not work unless I highlight the whole datasheet row (by clicking the record selector on the left). If I just click a particular record, the Form_Click doesn't recognise it. (I've even put in smg simple like debug.print &quot;Hello&quot;, but nothing happens). Any ideas why this is happening?<br>
<br>
Thanks,<br>
<br>
Kevin

 

[DougP]

Well that the way Access's Form click works.<br>
And you are confusing Record with field<br>
If you click to the left in the gray so you get an black arrow. You are indeed selecting a record. <br>
If you click in one cell you are selecting one field in that record.<br>
<br>
So what do you want to do once you select a field<br>
put that data somewhere?<br>
If so then <br>
If you want a particula fields data do go in something<br>
put this in the items On click event no the subforms on click.<br>
<br>
= Me![Labor subform].Form![MyField] <br>
Or click in the left and still put this same code.<br>
It will just get the filed or fields you want.<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>

 

[kevink]

Excellent stuff, Doug - Thanks a million!<br>
<br>
Kevin