Dim SelectionShowroom As String
Dim ActualFabric As String
Dim ActualFabricConstruction As String
'--------------------------------------- Fabric
If Me![WizardFabric] <> "" Then
ActualFabric = Me![WizardFabric]
Else
ActualFabric = ""
End If
'--------------------------------------- Fabric Construction
If Me![WizardFabricConstruction] <> "" Then
ActualFabricConstruction = Me![WizardFabricConstruction]
Else
ActualFabricConstruction = ""
End If
SelectionShowroom = " SELECT PictureShowroom.PictureAddress, PictureShowroom.ShowroomPictureRank, PictureShowroom.ShowroomStyleSystem, StyleShowroom.ShowroomStyleOwn, ....... , StyleShowroom.ShowroomFabric, StyleShowroom.ShowroomFabricComposition, StyleShowroom.ShowroomFabricConstruction, ....." _
& " FROM StyleShowroom INNER JOIN PictureShowroom ON StyleShowroom.ShowroomStyleSystem = PictureShowroom.ShowroomStyleSystem " _
& " WHERE (((PictureShowroom.ShowroomPictureRank)=1) AND ((StyleShowroom.ShowroomFabric) Like '" & ActualFabric & "') AND ((StyleShowroom.ShowroomFabricConstruction) Like '" & ActualFabricConstruction & "'));"
............
CurrentDb.QueryDefs("GetPictureShowroom").SQL = SelectionShowroom
Partager