Hey everyone,
At the moment I have an access program that contrains a list of products. When you double click, a generic report opens up. I then wrote three seperate reports (one for each of the three different types of products) and am attempting to write code that will open up the appropriate report depending on the product type.
Not too familiar with the visual basic language.
Right now my code just reads
Private Sub Combo46_DblClick(Cancel As Integer)
If [Table]![Basic Program Info]![Products] = "Red" Then
DoCmd.OpenReport "Reportx"
Else If [Table]![Basic Program Info]![Products] = "Blue" Then
DoCmd.OpenReport "Reporty"
Else
DoCmd.OpenReport "Reportz"
End If
End Sub
Not too sure if i am on the right track or not. Any input would be greatly appreciated.