Hi All,
I am very new to VBA. I am stuck up with one issue for more than a week:(.
My requirement is simple. on opening the access application, a form(Say Name=Products) should pop up with 2 fields (product ID and product Name) from a table called Products. The display should be in a table like fashion. There will be a detail button, Selecting a record and on clicking the button should take the user to another form(ProductDetails) which has some 10 fields pulling all the details of the selected record from the same table.
I am using a sub form named ProductSummary in the Form named Products to represent the data in a table fashion.
I am unable to display the details of the selected record in the second form. I have tried many things - Recordset, Recordsetclone, bookmark and what not. Since I am new to VBA, I am not sure whether I am using it correctly.
Pleez help me..
Thanks in advance,
Rakesh

Hi Rakesh,
Not sure if I understand 100%...but, here goes.
You can generate an SQL statement, to attach to the "RecordSource" property of the subform, to filter it accordingly.

SQL = "SELECT tblProducts.* " & _
       "FROM tblProducts " & _
       "WHERE tblProducts.ProductID =" & Me.ProductID & ";"

ProductDetails.Form.RecordSource = SQL

or, use the filter property of the subform.

ProductDetails.Form.Filter = Me.ProductID
ProductDetails.Form.FilterOn = True

I believe, my syntax is correct in both cases.
I used "ProductDetails" to reference the subform, it should be whatever you called it on the main form, not necessarily its actual name.
Hope this helps Rakesh, good luck!