If Form Field is populated, generate an additional report

[Me Ted]

hello,

I have a data entry form that's fairly straightforward. I have it set up
with a Button that prints out the current form record (as a report). My
questions is this. I need to generate an additional, simple one page report
ONLY if a certain field is populated. If it is not populated, then that
additional report would not print.

Is this possible?

TIA

 

[Arvin Meyer [MVP]]

Sure, add to your button (or other event) which starts the first report,
something like (untested):

If Len(Me.txtCertainField & vbNullString) > 0 Then
DoCmd.OpenReport "OtherReport"
End If