Deleting records on a form using VBA

[lawdy]

I have a sub form (sfProposal) linked to its master using the side by side method. Data in inputed into the sub form. This requires several records as each item on a job requires a separate record. Once it is all correct, a button is pushed. This does many calulations putting the data into other tables and finally on other sub forms.

Problem 1. The sub form, sfProposal, has done it job and the records need to be deleted. When I run the code "DoCmd.RunCommand acCmdDeleteRecord", I get a msg box saying "This record can't be deleted". I can delete the records manually. Also I can delete the records in the table using DAO, but on the form, each field on each record shows "#deleted".

Problem 2. In this same form, I am unable to move from one field to another using code "DoCmd.GoToControl "tbDblQuanity"". I get error code "There is no field named "tbDblQuanity" in the current record". Beleive me, it is there. I have tried every field using the field name and the control name.



Any help is appreciated.

[Missinglinq]

What kind of control is tbDblQuanity?

Where are you trying to use this code?

Linq ;0)>

[lawdy]

It is a datasheet field on a tab control on a sub form. I have a button on the same tab control that runs the code.

[lawdy]

I stated the previous wrong. The sub form (sfProposal) and the button are on the same tab control which is on a master form. Teh sub form (sfProposal) is not linked to any form. A tab control is just a handy place to put it.

[AlexHedley]

Are you Refreshing or Requerying the Form after running your Delete Query? This should remove the #Deleted.

[lawdy]

The refresh works great. Thank you very much. That was one of my 2 problems. I think I will show this one solved and open another for the other problem. Again, thank you very much.