Adding new records to Subform from another table

[JanetF]

Hello,

I have a complicated issue. I have a form with a subform, both of which
work perfectly. The main form is a Projects form, and the subform is a
continuous form which shows all the Tasks per Project. When users create a
new Project record, I want to have a button which allows them to add a
template to the Tasks subform. I have created a tblTemplate and a
frmTemplate which they can access from the Switchboard and therefore add
to/change. There will only be the one template, which will have three or
four (or more if they add more from the Switchboard) "default" records that I
want them to be able to plunk into the Tasks subform if they click on the
command button on the main Projects form. What I don't know how to do is
populate the subform with those Template records. Any ideas? I hope this
makes sense. Thanks in advance.

Janet

 

[jl5000]

To "submit" your records in the template to the table in the subform, run an
append query and send the Project Id from the main form along with the rest
of the information in the query, so your subform table is still connected to
the main form's table, after the append query, refresh/requery the sub form

 

[JanetF]

That's what I was trying to do, but because my subform is based on a query
(as is my main form), that makes it a little complicated. Also, there are
combo box fields in the subform. So my template table has incorrect data
types for some of its fields as I'm making them text, and they are numbers in
the subform table.

The subform is a based on a query so that the combo box fields can be
connected to their lookup tables. I don't know if this still makes sense,
but I'm at a total loss as to what to do here. I had already tried the
append query idea, but get many error messages as there are invalid data
types in my template table. Thanks in advance for any help you can give.