Advanced refresh

[kirky007]

I only want my refresh button to work (called command42) to work if there is a value in the hoursworked cell which is in the subform (called timesheet1).

Any ideas?

 

[iago18]

Put similar code in the OnClick() event of command42...

If not isnull(Forms![Timesheet1]![HoursWorked]) then
'Perform refresh
end if

You might also be able to reference a control in the subform using: Form.Subform.Control ...