This is rather complicated to explain, but it's probably pretty simple, actually.
I want an administrative form where you can enter the PRODUCT_ID field as the "filter" and then there are 2 fields below it where you can add in info. What I want a button in the form to do is trigger a query to update all records with the same PRODUCT_ID with the information I put in the 2 fields below.
Example
UNIQUE_ID: 40882
Rec_Date: 10/24/02
Rec_By: TRI
There are 42 records with PRODUCT_ID as 40882. I want the Rec_Date and Rec_By fields in all of those records to be updated (filled in) with the data above. So each of the 42 records will have Rec_Date of 10/24/02 and so on.
How can I do this? And is the easiest way to enter VB in the form or to trigger an Update Query of some sort. Either way, I need specific help setting it up, as I'm new to this type of thing!
Thanks for all the help!!!
I want an administrative form where you can enter the PRODUCT_ID field as the "filter" and then there are 2 fields below it where you can add in info. What I want a button in the form to do is trigger a query to update all records with the same PRODUCT_ID with the information I put in the 2 fields below.
Example
UNIQUE_ID: 40882
Rec_Date: 10/24/02
Rec_By: TRI
There are 42 records with PRODUCT_ID as 40882. I want the Rec_Date and Rec_By fields in all of those records to be updated (filled in) with the data above. So each of the 42 records will have Rec_Date of 10/24/02 and so on.
How can I do this? And is the easiest way to enter VB in the form or to trigger an Update Query of some sort. Either way, I need specific help setting it up, as I'm new to this type of thing!
Thanks for all the help!!!