You can use this method to add it to the table, then requery the subform, which would then display it.
You can use this method to add it to the table, then requery the subform, which would then display it.
Thanks. When the record is added it does not add the auto-number field? Never mind; it does add the auto-numbering to the subform record; I just need to figure out how to attach it to the main record that is opened already.
Presumably you can add that field after the AddNew and get the value from the main form.
Thanks, that's what I did and it worked like a charm.
Happy to help and welcome to the site by the way!