J JOWINO New member Local time Today, 03:19 Joined Jul 12, 2024 Messages 1 Jul 12, 2024 #1 DoCmd.OpenReport "YourReportName", acViewNormal, , "[YourFieldName] = '" & Me.FieldName & "'"
theDBguy I’m here to help Staff member Local time Yesterday, 17:19 Joined Oct 29, 2018 Messages 21,882 Jul 12, 2024 #2 Welcome to AWF! JOWINO said: DoCmd.OpenReport "YourReportName", acViewNormal, , "[YourFieldName] = '" & Me.FieldName & "'" Click to expand... Try using acViewPreview instead of acViewNormal.
Welcome to AWF! JOWINO said: DoCmd.OpenReport "YourReportName", acViewNormal, , "[YourFieldName] = '" & Me.FieldName & "'" Click to expand... Try using acViewPreview instead of acViewNormal.
Ranman256 Well-known member Local time Yesterday, 20:19 Joined Apr 9, 2015 Messages 4,341 Jul 12, 2024 #3 the default NORMAL means print. (i wish it was the other way)
Gasman Enthusiastic Amateur Local time Today, 01:19 Joined Sep 21, 2011 Messages 15,270 Jul 12, 2024 #4 JOWINO said: DoCmd.OpenReport "YourReportName", acViewNormal, , "[YourFieldName] = '" & Me.FieldName & "'" Click to expand... Ever considered looking up the syntax? DoCmd.OpenReport method (Access) Office VBA reference topic learn.microsoft.com
JOWINO said: DoCmd.OpenReport "YourReportName", acViewNormal, , "[YourFieldName] = '" & Me.FieldName & "'" Click to expand... Ever considered looking up the syntax? DoCmd.OpenReport method (Access) Office VBA reference topic learn.microsoft.com