Problem with Domainfunction

[TURabbIT]

I intendet to get a Value from a Query for a textbox, so I tried to use the Domainfunction DFirst.

=DFirst("[SAPANLAGE]";"[Query_Anlage_42]")

but now the box just shows #error and blinks like crazy.

I have no idea whats the problem with that, anybody an idea?

 

[vbaInet]

What value are you trying to get?
Where did you place this code?
Tell us the field name and the name of the table.

 

[JHB]

Depend on where you use it, then change the ";" to ","

=DFirst("[SAPANLAGE]"[B][COLOR=Red];[/COLOR][/B]"[Query_Anlage_42]")

 

[TURabbIT]

I try to get any value from the query
[Query_Anlage_42] at [Query_Anlage_42]![SAPANLAGE]
and insert this value in a textbox in a subform.

I tried the code in the properties in the field for the element content.

The help told me to use this syntax with ';' and without this the field just shows "#Name" and access tells me there is an syntax error in the line

 

[vbaInet]

You should get an "invalid syntax" error with one of them.

Who said you should use the semi-colon? Do you have any other function that works with the semi-colon?

 

[TURabbIT]

The ';' is correct. Pretty sure.
Several How-Tos from the web and the access help for DFirst told me to use the semicolon.
Any integrated function (like "if" and so on) uses semicolon to seperate the syntax parts of the command.

Without semicolon I get syntax error.

 

[vbaInet]

Ok.

Not that it should make any difference, but have you tried DLookup()?
Where are you using this function? In a textbox on a report or a form?

 

[TURabbIT]

The textbox is in a subform and the code (tries to) refers to a query.

The code is in the content field for the attributes of this textbox

 

[vbaInet]

So have you tried DLookup()?

 

[JHB]

Are you really the query return a field name = [SAPANLAGE], (open/run the query and check it)?

 

[TURabbIT]

Tried it with DLookup("SAPANLAGE"; "[Query_Anlage_42]")

So somehow it works now

THANK YOU!

 

[vbaInet]

I find that weird. But good to know it works!

 

[TURabbIT]

I learned while working with access / microsoft:
Don't try to understand why it works as long as it works.
Sometimes there are such weird connections that cause trouble, i stopped asking.

 

[vbaInet]

I always ask and there's always an explanation