Validate Subfrom Data

[mcktigger]

Hi



This has annoyed me for sometime and was wondering if there is a solution.

I have a form FrmOrderHeader with a subfrom subFrmOrderLines. On the main form FrmOrderHeader I have a save button which checks if all fields are completed corerctly. This save button also has the following code

if IsNull(Forms!FrmOrderHeader!FrmOrderLines!Descript ion) Then
MsgBox "Please enter a description"
Me![FrmOrderLines].SetFocus
Me![FrmOrderLines].Form![Description].SetFocus
end if

This works if there is no 2nd blank line on the subfrom but because a new row is always created after the first row is entered the record can't be saved since Description will always be blank.

Is there a way to check the fields on the subform are completed correctly. I don't really like using the BeforeUpdate event on the subform since users can move focus back to the main form.

Thanks for any help.

[rpeare]

Your subform should not be creating a second blank record unless you've got some code running in on exit, after update, on dirty type event. I would look at the code in your subform to find out why that record is being generated and prevent it from happening unless a certain criteria is met.

[mcktigger]

Hi

Thanks for the reply. There is no code on any of the subform events. I think it is standard for a new record row to be created automatically when you enter data into the first line.