Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Set function From String

Status
Not open for further replies.

checkOut

Technical User
Oct 17, 2002
153
NL
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

 
The 'eval' function returns the result of evaluating the string expression; e.g.

Eval("1 + 2") returns 3

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top