How can auto delete sub form's blank row

[deepaksharma]

Hello to all of you,

I have created an order booking program for a clothing store which has a
There is a main form and a sub forms located in it. In the main form, customer related information is entered, while in the sub form, the shed and meter related to the cloths ordered are entered. The data of main form is entered in the gray offer table and the data of sub form is entered in the gray shade table.

There are total four fields in the gray shade table, one is auto number, second is gray ID, third is shade and fourth is meter. The gray ID field is created for greyoffer table to table relation.

1. I want that whenever a new order is entered, in addition to the shed and meter, a serial number field should also be shown temporarily in ascending order in the sub form.

2. When the user open any old record in for editing and make any row empty by deleting shade and meter from any row in the sub form, then that empty row is unnecessarily shown in the print preview. I want that if the user deletes the data of any row from the sub form during editing, So that row itself should be removed from the table.

Please give your suggestions.
Thank you.

[Welshgasman]

Do not allow the data to be removed once entered. Make the user delete the record after confirmation.

[deepaksharma]

Do not allow the data to be removed once entered. Make the user delete the record after confirmation.

This will not solve the problem because even while entering a new record, the data of the row can be cleared by moving the cursor to the previous row.

[mike60smart]

You can put a Delete button in the detail area of the subform.
When used it will ask for Confirmation of Deletion.

[Welshgasman]

This will not solve the problem because even while entering a new record, the data of the row can be cleared by moving the cursor to the previous row.

No, the data will be saved if you move to another row, next or previous.

[deepaksharma]

No, the data will be saved if you move to a another row, next or previous.

You are right, the blank data row will be saved automatically with its autonumber entered.
Is there any method that can be implemented in the BeforeUpdate or "move on next row" event of the sub form to delete the entire row if the data of special field of the current record in the sub form is not present in the row.

[deepaksharma]

You can put a Delete button in the detail area of the subform.
When used it will ask for Confirmation of Deletion.

Thanks Mike your method is working can it be put in the code with the above condition mentioned by me. post #6

You are right, the blank data row will be saved automatically with its autonumber entered.
Is there any method that can be implemented in the BeforeUpdate or "move on next row" event of the sub form to delete the entire row if the data of special field of the current record in the sub form is not present in the row.

[Bob Fitz]

Form validation is best done in the Forms Before Update event which can be cancelled if the validation fails using Cancel = True
You might also need the line Me.Undo

[mike60smart]

In the Before Update of the Subform you can validate the Record

If Me.[data of special field] Is Null then

Code to delete the record

[Welshgasman]

You are right, the blank data row will be saved automatically with its autonumber entered.
Is there any method that can be implemented in the BeforeUpdate or "move on next row" event of the sub form to delete the entire row if the data of special field of the current record in the sub form is not present in the row.

You do not save it in the first place? :-(

Hardly rocket science?

That is what the beforeUpdate event of the form is for?

https://www.access-programmers.co.uk...-and-2.324342/

[Welshgasman]

In the Before Update of the Subform you can validate the Record

If Me.[data of special field] Is Null then

Code to delete the record

Record would not be saved then Mike, so no option to delete?
One would just stop it being saved with that event?

[deepaksharma]

In the Before Update of the Subform you can validate the Record

If Me.[data of special field] Is Null then

Code to delete the record

sorry but this is not working

[mike60smart]

What Code did you use?

[Welshgasman]

sorry but this is not working

See post #11 as to why

[mike60smart]

Yes you are right, stupid of me to use Delete