VBA in Datasheet View?

  • Thread starter Thread starter grep
  • Start date Start date
G

grep

I wrote the following code in the DblClick event in a subform:
me.Date = Date

The subform uses Datasheet view. In this view, when I double-click the
Date field, nothing happens. Why not? Can you use VBA in Datasheet view?

grep
 
Try changing the name of your control from Date to something else. Date is a
reserved word: you should never use it for anything you create.
 
grep said:
I wrote the following code in the DblClick event in a subform:
me.Date = Date

The subform uses Datasheet view. In this view, when I double-click the
Date field, nothing happens. Why not? Can you use VBA in Datasheet view?
Click to expand...


Also check if you are using the date text box's DoubleClick
event or the form's event? The form's event will only fire
if you dlick in the record selector box.

Are you sure you want to change the value of the field/text
box even if it was already set? If not, check to see if the
text box contains Null before setting the value.

Are you aware that there is a built-in keyboard shortcut
(Ctrl ;) to do this?
 
Back
Top