I am using Access 2003.  I am familiar with the very basics of VBA but I
think my problem can be solved with some help regarding vba and syntax.

We refurbish & recover rollers from paper producing machines at our
facility.  I am working on a database that will centralize al the data that
is generated when the roll comes in for service.  Currently each dept keeps a
record of just what they do.  Below is sample production route that I have
simplified:

1. The Roll is recieved and given a unique sales order number.
2. Roll goes through an inspection process.
3. Roll receives a new cover.
4. The new cover is ground to customer specs.
5. Roll is balanced.
6. Roll is shipped to customer.

I have created a main form (roll_data) that is the main screen for
monitoring a roll through the plant.  The customer service rep creates a new
record when received in the roll_data form with basic info for the roll along
with the customer info and assigns a sales order number.  The roll_data pulls
certain info from the forms listed below for ease of viewing instead of
pulling up every form.

Additional forms include the inspection_form, cover_form, grinding_form,
balance_form and shipping_form.  Each form has it's own table using the sales
order number as the primary key.  Each department populates the appropriate
field with data for the roll. Example: The Grinding dept will populate the
grinding_form and so on.  I had to split each process into it's own
form/table due to field limitations in access.

The problem:  If I have a roll for sales order 402818 displayed on the main
form (roll_data) and click one of the links I have to another form
(inspection, cover, grinding, balance, shipping), I want it to pull up the
appropriate form for sales order 402818.  Instead, it pulls up the first
record in that table.

I have researched it here and it sounds like I will need to apply some sort
of filter or where staement to the button to carry the sales order (primary
key for each table) forward.  I have even played with the OpenArgs statement
with no success.

Please understand that I am an IT person by trade but have not had alot of
experience with actual coding.  It has been difficult for me to get out of my
Excel mindset.

Thanks for any and all help!