DLOOKUP on forms 1

[slames]

Hi
I am trying to use form text box values as the criteria for the dlookup, but am getting an #error! showing.
Is it possible to do this and if so do I have a syntax error in this:

=DLookUp('" & [Forms]![FRMEDIT]![MAGID] & "','" & [Forms]![FRMEDIT]![MAGTable] & "','" & [Forms]![FRMEDIT]![MAGISSUE] & "' & " = " & '" & [Forms]![FRMEDIT]![FROM_ISSUE] &"')

Thanks in advance

Steph

 

[Mute101]

Hi,

You have way too many quotes in there

Same form:

= DLookup(Me.txtField, Me.txtTable, Me.txtCriteria & " = " & Me.txtClause)

Sub form

= DLookup(Forms!MainForm!SubForm.txtField, Forms!MainForm!SubForm.txtTable, Forms!MainForm!SubForm.txtCriteria & " = " & Forms!MainForm!SubForm.txtClause)

Hope that helps
Sim



----------------------------------------
I was once asked if I was ignorant or just apathetic. I said, "I don't know, and I don't care."
----------------------------------------

 

[slames]

Thanks for your reply - that has got me half of the way! Although I am still having trouble with the criteria part of dlookup.
I couldn't use me. as it the object did not contain the automation object me.

This is what I thought it should be but I can't get the criteria bit to work:
=DLookUp(Forms!frmEdit!MagID,Forms!frmEdit!magTable,Forms!frmEdit!issue=forms!frmEdit!fromissue)

It works this far:

=DLookUp(Forms!frmEdit!MagID,Forms!frmEdit!magTable,"medIssue ='2-4'")

The value of the text box issue is 2-4 in this instance. It is a text value.

Can anyone help me with this?

Thanks

Steph

 

[Mute101]

Ello,

Change your criteria to:

Forms!frmEdit!issue & " = " & forms!frmEdit!fromissue

or if needs be:

Forms!frmEdit!issue & " = '" & forms!frmEdit!fromissue & "'"

If you need the exrea set of quotes.

That should fix the problem you were having.
Sim

----------------------------------------
I was once asked if I was ignorant or just apathetic. I said, "I don't know, and I don't care."
----------------------------------------

 

[slames]

Fantastic, working fine now.
Thanks