Record in subform won't allow deletion

[trish]

hiya

i have a subform which won't allow me to delete a record unless i'm in the datasheet view. is there anyway to change this. the properties have been set to allow deletions.

thanks
trish

 

[RuralGuy]

What method are you trying to use to delete records when in other than datasheet view? What is the Default View of the SubForm

 

[trish]

i'm selecting the line by right clicking then using the options available. i.e. new record, delete record, cut, paste etc.

the default view is continuous forms.

 

[RuralGuy]

Are you building an application for someone else to use? Do you plan to leave the Right Click short cut menus in the application?

 

[trish]

Yes this application is to be used by someone else, however there will only 2-3 max people using this. I actually wanted to remove the shortcut options and have command buttons (although don't know whether this is possible with a subform in a main form), but at the moment my skills are still very limited so eventually when i get to it, i will probably be trawling for answers on this forum

 

[RuralGuy]

Yes, command buttons on subforms in continuous form view that delete records are common. I've not used the shortcut menu system before and turn them off in my applications. I could suggest some diagnostic methods to pin down what is happening if you like or maybe someone else more familiar with the shortcut methods will cruise by.

 

[trish]

any suggestions would be great! can't say that i'll understand, but if you put it in laymen's terms i'm sure i can figure it out.

 

[RuralGuy]

Place a new TextBox on your main form and set the Control Source to:

=SubFormControlName.Form!NameOfControlOnSubForm

Replace my PsudoNames with your actual names. If the Data is different in each record of the SubForm you will be able to see what record the MainForm thinks is current on the SubForm.