I made a wizard but struggled in the following problem
Using access 2002.
Have a table with FldName, strCode
Each fldName has its own code, p.e.:
FldName strCode
Mut_text Dlookup("Mut_text","tblMut",".."
Mut_datum Dlookup("Mut_datum","tblMut",".."
and so on
The problem is, when I read strCode from the table it handles the function as string, so it pasted the whole string in the field.
I call it with:
me.mut_text = dlookup(""strCode","tblCodes","..."
Can somebody help with this problem?
Thnx in advance,
Gerard
Using access 2002.
Have a table with FldName, strCode
Each fldName has its own code, p.e.:
FldName strCode
Mut_text Dlookup("Mut_text","tblMut",".."
Mut_datum Dlookup("Mut_datum","tblMut",".."
and so on
The problem is, when I read strCode from the table it handles the function as string, so it pasted the whole string in the field.
I call it with:
me.mut_text = dlookup(""strCode","tblCodes","..."
Can somebody help with this problem?
Thnx in advance,
Gerard