Hallo,
for now i have an Form with a combobox, where i can select an worker and then click Macro (Button) to open an Report. This report is a Dokument (.png from former pdf form) where i fill in names, adresses etc based on combobox selection. The Problem is that with the Button i want also be able to change the .png picture based on column 4 in combobox called "status".
My IF statement idea is for now
[Forms]![fFillDoku]![cboWorker].[Column](3)="retired"
with Open Report and WHERE condition
[Reports]![rDoku]![Attachment].[DefaultPicture]="First1.png"
but this does not work. Is there any way to make it work with Where condition on open Report?
thx
Stas