Search results

Merry Christmas!! For field validation I an using the before update event to trap for errors. On the form I have a close button which should rollback changes and close the form. I am finding that when I press this close button the before update event of the field is activated and because...

Oh I see. And there is no workaround??

Thanks Graham T and Saintsman!!! Both of your suggestions work.

I have a subform that I want to display in datasheet mode. I set one field to display in red font but it does not work when displayed in datasheet mode. Is this a limitation??? thanks.

I have a subform which i chose to display in datasheet format. I set a particular field's property to hidden but it still appears in the datasheet. Is this a limitation of Access or am I doing something wrong here. Thanks in advance.

Is there a way in VB to reference the individual cell contents of the datasheet. When I press a button on the main form I want to be able to read the contents of certain cells in the datasheet and then act on it.

Is it possible to return a query result within a "datasheet" within a form. The current default is just a "datasheet" which is quite ugly and cumbersome.

How can I cancel changes made to subform records? I tried Me.Undo in a command button on the main form but it does not work. Any help will be appreciated. Thanks.

Sudha, Did you find out eventually how to do it as I also have the same dilemma. How can cancel update work both on main form and subform?? Thanks.