Report not drawing info from form unless I click in field

[sweetaud]

I have a form which displays list-box fields based on 2 dropdown/combo boxes. The pool of data that the form works on is from a query involving several tables.

The form seems to work fine - it correctly filters and displays the fields based on the 2 combo-boxes.

However, it seems that while the fields DISPLAY the results, the report which reads the fields does not acknowledge the data displayed UNLESS I actually click on each field on the form. It is not updating the field I guess. I am no Access expert, so perhaps something is wrong, but I can't see what as it "works" when I click the fields.

For example I have following fields:

>>ListBox on Form:

Row Source Type: Table/Query
Row Source: SELECT [qvrFoljeSedel].[Beställare] FROM [qvrFoljeSedel] WHERE [qvrFoljeSedel].[tblProv_KokID] = [Forms]![frmFoljeSedel]![KokID] AND [qvrFoljeSedel].[tblProv_ProvtagareID] = [Forms]![frmFoljeSedel]![ProvtagareID]


>>TextBox on Report:

Control Source: =IIf([Forms]![frmFoljeSedel]![Bestallare2] Is Not Null;[Forms]![frmFoljeSedel]![Bestallare2];[Forms]![frmFoljeSedel]![Bestallare])

Any help will be GREATLY appreciated !

Thanks Much

Aud.