Forms: Viewing Continously and then Seeing Detail

[rysch]

I apologize that my title is a little confusing. I'm a little confused on how to present my issue.

I have a table called Inventory Transactions. I have created a form called Inventory Transactions to show the Processing ID, Product Category, Product Type, Product Name, Distribution Priority, and its Destination.

I am viewing this on a continuous form so I can see a list of records. However, there are more fields than just the ones I listed above. But I don't want to display all of the fields in the continous form because it would take up a lot of space.

I want to be able to view detailed information about each record by clicking on a link which could be placed next to each.

I will try to setup what the form looks like right now:

Click to View Processing ID Product Category Product Type ... ... ...
View Detail 1 Clothing/Shoes Children's Shoes
View Detail 2 Household Items Computer

Since I am only seeing five fields out of about twenty, I now want to click on view detail to see all of the information about one single product.

I have created another form called Inventory Management Detail

I hyperlinked "View Detail" to that form. When I open the form, I don't see the individual information of the record that I selected.

Say I click on View Detail next to record 1. I do not see the unique information for record 1.

How do I see a unique detail view for each record?

Thank you.

Apologies again for being confusing.

 

[pbaldy]

The code would look something like this:

  Dim stDocName As String
  Dim stLinkCriteria As String

  stDocName = "frmEditRes"
  
  stLinkCriteria = "[ResNum]=" & Me.txtResNum
  DoCmd.OpenForm stDocName, , , stLinkCriteria

 

[rysch]

The code would look something like this:

  Dim stDocName As String
  Dim stLinkCriteria As String

  stDocName = "frmEditRes"
  
  stLinkCriteria = "[ResNum]=" & Me.txtResNum
  DoCmd.OpenForm stDocName, , , stLinkCriteria

Thank you for your quick reply!

It worked perfectly!

I appreciate your help!