Z
ZigZagZak
I have a form that looks up a stock part duplicates its fields & changes its
order number field from stock to the actual job number I am applying it to.
I have a subform on the page that shows the parts that have been applied to
that job number. I used a simple query for that subform. what I would like
it to do, is automatically requery when I press the button to duplicate the
record. I can't figure out how to get it to do it because the duplicate
button is on a seperate subform from the job number query form. Hopefully
that makes since. Any help would be great.
order number field from stock to the actual job number I am applying it to.
I have a subform on the page that shows the parts that have been applied to
that job number. I used a simple query for that subform. what I would like
it to do, is automatically requery when I press the button to duplicate the
record. I can't figure out how to get it to do it because the duplicate
button is on a seperate subform from the job number query form. Hopefully
that makes since. Any help would be great.