dlookup or dsum

[smason]

hello i have writen this code in a form called frminput
=DLookUp("[amount]","[qryamttotal]","[jobid]= " & [Forms]![frminput]![jobno])

to retrieve a sum cell in a query(qryamttottal) called 'Amount'
the field in the form is 'jobno' and i am tring to link this to 'jobid' and
the query which are the same but i am getting an error message in the text
box any ideas

 

[Jeff Boyce]

"getting an error message" doesn't give us much to go on...

More specific description may lead to more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[fredg]

hello i have writen this code in a form called frminput
=DLookUp("[amount]","[qryamttotal]","[jobid]= " & [Forms]![frminput]![jobno])

to retrieve a sum cell in a query(qryamttottal) called 'Amount'
the field in the form is 'jobno' and i am tring to link this to 'jobid' and
the query which are the same but i am getting an error message in the text
box any ideas

Access tables and queries do not have 'cells', they have fields.
Forms do not have fields, they have controls.

What is the error message?
What version of Access?
What is the datatype of [jobid]?

As written, your syntax indicates that [jobid] is a Number datatype.

If, in fact, it is a text datatype then use:
"[jobid]= '" & Me]![jobno] & "'"

Note: the Me! keyword replaces forms!frminput

 

[smason]

thank you fredJ

how ever i tried this
=DLookUp("[amount]","[qryamttotal]","[jobid] = '" & [me]![jobid] & "")
and i get an error in the text box saying #Name

hello i have writen this code in a form called frminput
=DLookUp("[amount]","[qryamttotal]","[jobid]= " & [Forms]![frminput]![jobno])

to retrieve a sum cell in a query(qryamttottal) called 'Amount'
the field in the form is 'jobno' and i am tring to link this to 'jobid' and
the query which are the same but i am getting an error message in the text
box any ideas

Access tables and queries do not have 'cells', they have fields.
Forms do not have fields, they have controls.

What is the error message?
What version of Access?
What is the datatype of [jobid]?

As written, your syntax indicates that [jobid] is a Number datatype.

If, in fact, it is a text datatype then use:
"[jobid]= '" & Me]![jobno] & "'"

Note: the Me! keyword replaces forms!frminput

 

[Douglas J. Steele]

You appear to have a single quote before the value of jobid, but not after.

It would also appear from the equal sign in front that you're trying to use
the DLookup as the ControlSource for a text box. You cannot use Me in that
context: you must use the complete reference to the form (or else just put
the control name with no qualfication)

=DLookUp("[amount]","[qryamttotal]","[jobid] = '" &
[Forms]![FormName]![jobid] & "'")

or

=DLookUp("[amount]","[qryamttotal]","[jobid] = '" & [jobid] & "'")

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

thank you fredJ

how ever i tried this
=DLookUp("[amount]","[qryamttotal]","[jobid] = '" & [me]![jobid] & "")
and i get an error in the text box saying #Name

hello i have writen this code in a form called frminput
=DLookUp("[amount]","[qryamttotal]","[jobid]= " &
[Forms]![frminput]![jobno])

to retrieve a sum cell in a query(qryamttottal) called 'Amount'
the field in the form is 'jobno' and i am tring to link this to 'jobid'
and
the query which are the same but i am getting an error message in the
text
box any ideas

Access tables and queries do not have 'cells', they have fields.
Forms do not have fields, they have controls.

What is the error message?
What version of Access?
What is the datatype of [jobid]?

As written, your syntax indicates that [jobid] is a Number datatype.

If, in fact, it is a text datatype then use:
"[jobid]= '" & Me]![jobno] & "'"

Note: the Me! keyword replaces forms!frminput