K
kev5
I am using a form to update invoice entries. The form pulls info (the
funding source) from a different table, based on a parameter query. When I
enter the parameter info, the query populates the funding fields
automatically from the funding table. This works great. My problem is I
then enter invoice info (amounts) in the form for each funding source. When
I check the invoice table, the amounts are there, but the funding source info
is not.
Somehow the table is only taking the info I am typing in on the form, but
not the info that is being supplied through the parameter query for the form.
Can anyone help? I need the amount as well as the funding source info to be
saved from the form.
funding source) from a different table, based on a parameter query. When I
enter the parameter info, the query populates the funding fields
automatically from the funding table. This works great. My problem is I
then enter invoice info (amounts) in the form for each funding source. When
I check the invoice table, the amounts are there, but the funding source info
is not.
Somehow the table is only taking the info I am typing in on the form, but
not the info that is being supplied through the parameter query for the form.
Can anyone help? I need the amount as well as the funding source info to be
saved from the form.