Possibly silly question - using form for dsata entry.

[kimberlin]

I am just creating my first ever form and it needs to have two sub forms included in it because of the one to many relationships between the data. On the main form, do I need to have a field for the worker id as it would be automatically assigned and would I also be able to use the same form to update the existing records?

 

[John Big Booty]

So long as the ID forms part of the Record Source of the Form and SubForm. It doesn't need to appear as a field on either form.

Yes the same form should be able to be used to update existing records. You can control this using the form's Data Entry property. Also have a look at the Allow Edits property.

 

[kimberlin]

Thanks for the reply, I'll go ahead and delete the ID field from the form and sub-forms I've been working on today in that case.