Delete records from continuous form 2

[Joallyn]

Hi, I have a question about forms and deleting records...

I have a main form and a subform:

frmActions
subfrmPersonnel

If my subform is in 'continuous forms' view, I cannot delete a person without getting an error (specifically, "You tried to assign a Null value to a Variable that is not a Variant data type".) If I change the view to "datasheet", then I can right-click next to the person's name and delete it without a problem.

I'd like to keep the continuous forms view. Is there another way to delete records?

thanks,

J

 

[LittleSmudge]

How are you trying to do the delete ?

Does your continuous form have record selectors ?

Are you using the Delete tool on the toolbar ?

Are you just deleting the values from the field ?

Does the error message tell you which variable ?

Is any code running to do the Delete - or as a result of the Delete event ?





G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

 

[Joallyn]

Hi LS,

I got to question 2 and thought, "Hmmmm...". Sure enough, turning on the record selectors fixes the problem.

I was trying to delete by highlighting and then hitting delete--which is exactly how I imagine most people using the dbase will try to do it. I should have known that since that in the Northwind dbase doesn't work, either, it was going to beat me.

thanks for the speedy fix!

J