Z
ZigZagZak
I have a table that has the fields "part number" "branch cost" "description"
& "purchase order number". I want to enter our stock parts onto this table.
Then I set up a query to find the part we need for a job. once the correct
part is found I want to apply the job number or "purchase order number" to
that & have it save to the table as a new entry.
So, with that said. On my queries form, I have my fields for the query & a
subform for the query to fill in. Then I have fields on the bottom of the
form which I plan to hide. I want the fields to take their data from the
query that is on the subform and save it as a new entry on the original
table. The only place I know of to write the expression is in the control
source, but that is already being used for sending the data to the table.
Hopefully this makes since, any help is appreciated.
& "purchase order number". I want to enter our stock parts onto this table.
Then I set up a query to find the part we need for a job. once the correct
part is found I want to apply the job number or "purchase order number" to
that & have it save to the table as a new entry.
So, with that said. On my queries form, I have my fields for the query & a
subform for the query to fill in. Then I have fields on the bottom of the
form which I plan to hide. I want the fields to take their data from the
query that is on the subform and save it as a new entry on the original
table. The only place I know of to write the expression is in the control
source, but that is already being used for sending the data to the table.
Hopefully this makes since, any help is appreciated.