disale right click in subform

[msasan1367]

how to disable right click in subform?

[June7]

Try setting ShortcutMenu property of form to No.

[msasan1367]

Try setting ShortcutMenu property of form to No.

I do it but it just disable right click in form not in subform

[June7]

Then you didn't set the property of the subform, you set the main form property. Open the subform indpendently in design view.

[msasan1367]

Then you didn't set the property of the subform, you set the main form property. Open the subform indpendently in design view.

my subform is table and it hasn't this option in its properties

[June7]

Then will have to make a form with that table as its RecordSource to use as subform.

[msasan1367]

Then will have to make a form with that table as its RecordSource to use as subform.

I do it and at form I disable right click, but at table that is subform, right click is allowed
Here is my project:
Database11.zip

[June7]

Did you not understand my advice? Create a form with the table as its RecordSource and make that form the SourceObject of the subform container control.

Why do you even need a subform? why is the table not the RecordSource for the main form? Why do you have a system table as the RecordSource for main form?

[msasan1367]

Did you not understand my advice? Create a form with the table as its RecordSource and make that form the SourceObject of the subform container control.

Why do you even need a subform? why is the table not the RecordSource for the main form? Why do you have a system table as the RecordSource for main form?

because I want to add buttons at form for searching & sorting subform

[June7]

Those buttons can be on the same form as the data you want to search. Review http://datapigtechnologies.com/flash...tomfilter.html

Set the form as Continuous View if you want a datasheet appearance. Controls can be arranged to look like datasheet. Put buttons in header or footer section.

Still doesn't explain why the main form is bound to a system table.

[msasan1367]

I find it: just need to go file > options > current database and disable Allow Default Shortcut Menus

[June7]

Yes, that does it for everything. Thought you only want it for the one form. Glad you got it solved.