Limited view on Form/Or edit data

[VKKT]

Hi All

Hope all are fine here.

I have a database for recording the man hours which are recorded by each staff on a daily basis through a separate Entry Form created for each staff.

Is it possible to restrict the staff to see the data only for the current month, in order not to allow them to make any changes to the previous entries.

Or is there any other way to restrict them to not edit the data for the past months.

regards,
VKKT

[HansV]

You could create a query that selects records for the current month, and use that query as record source for the form. That way, only those records can be viewed and edited.

[VKKT]

Thanks a lot Mr. Hans, it is working..