Sort ends data entry mode

[dougie]

I have a form contaiing a subform. The subform is opened in data entry mode, so it displays no existing records. Howvere if the user right-clicks the form and selects a sort, all records are displayed. Is there any way to stop this behaviour so that the form remains in data entry mode?

[Rainlover]

There are a couple of ways of doing this.

The first that comes to mind is to change your Record Source.

But first, what is it that you want to achieve. When I know this it will be easier to make a better recommendation.

[dougie]

On the parent form the user chooses a date and a work cell. On the subform which is in data entry mode, the user enters production figures for that date and work cell. As the subform is in data entry mode, only the data entered by the user at that session is visible. However if the user right clicks on the subform they can see the context menu allowing them to sort the data. Instead of this sorting the data on display, the subform displays the entire contents of the table that it is attached to - in other words, it is no longer in data entry mode. Ideally I want to disable sort, filter etc when in data entry mode, or find some way of overriding the undesired termination of data entry mode if these are invoked.

[Rainlover]

Give me a few minutes to check something.

[Rainlover]

Sorry about that. Just wanted to make sure I was right.

Open your SubForm in design View. In the Properties Box you can set the "Shortcut Menu" to no.

This will disable your right click for that subform.

[dougie]

Many thanks.