source of control on a form

[MarionD]

Hi there,

I used this statement in a control on a main form to establish if there were records in the sub form. If there are, I display the name on the sub form, if not the field should remain blank.

It works perfectly in 2003 but if I run the DB on 2007 I just get "name?" displayed in the field.
Can anyone tell me why it cant read it in 2007, and what I should change?

=iff([frm_Verstorbener].[Formular].[RecordsetClone].[RecordCount]=0;Null;[frm_Verstorbener].[Formular]![vorname] & " " & [frm_Verstorbener].[Formular]![nachname])

 

[CEH]

Shouldn't your semi colons be commas?

 

[missinglinq]

Depends on the regional settings; not all use commas as delimters. frm_Verstorbener and nachname would indicate something other than an American/English version of Access.

Where do you have this code placed? Code does not run in 2007 unless your database resides in a folder that has been declared a “trusted” location.

To trust your folder, click:

Office Button (top left)
Access Options (bottom of dialog)
Trust Center (left)
Trust Center Settings (button)
Trusted Locations (left)
Add new location (button)

 

[MarionD]

Thanks for the answers. The code is placed in the form itself - not in VB but in the properties in the control source of the control. That's why I've used semicolons and not commas. Commas only work in VB
It's a German Version.
The Db is in a trusted file.

Grüße from Germany!