DLookup in subform

Thanks. I'll split the taskMaterials table and see what happens then - if
this was the problem, I'll post in a day or 2. Thanks again.

"AccessVandal via AccessMonster.com" wrote:

I like to add further, if the textbox "material" and if it is blank or empty
it will produce an error. Like what you have posted "#Error".

kasab wrote:
Thanks again for staying with me.

--
Please Rate the posting if helps you

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200709/1

I think this line needs to be changed:
[Forms]![frmNewQuote]![subfrmOptions].[Form]![materials]

It should be:
[Forms]![frmNewQuote]![subfrmOptions].Form![materials]

"Form" after [subfrmOptions] should not have the square brackets, since it
is a property and not a field or control.

"kasab" wrote in message
...
Yes, the Name property of the control that contains the data on the
subform
that is used in the DLookup is "materials" as used in the DLookup.

The subform RecordSource is the quotes table that contains the field
"materials" (text datatype).

And the DLookup works fine in the (sub)form displayed in form view on its
own.

"AccessVandal via AccessMonster.com" wrote:

So, your're saying the subform RecordSource is not part of the DlookUp.

Does the control "material" is the name of the control? Check the
"material"
properties under the Tab "Other" and look the Name field.

kasab wrote:
Thanks again for staying with me.

If I read you correctly, materials may be missing from the subform's
fields?
No. This is taken directly from another table, not a query. Also, both
fields
(description in taskMaterials table and materials in subfrmOptions) and
the
table have correct spelling in the DLookup.

=DLookUp("[TableName].[price]","[taskMaterials]","[TableName].[description]=
' " &
[Forms]![frmNewQuote]![subfrmOptions].[Form]![materials] & " ' " )
isn't working.

Both materials and the DLookup textbox are in the subform.

Also, no difference with
=DLookUp("[price]","[taskMaterials]","[description]= ' " &
Me!materials & " ' " ) or
=DLookUp("[price]","[taskMaterials]","[description]= ' " &
Forms!subformOption.materials & " ' " )

If I use a (sub)subform based on a query instead of a DLookup, I'll need
to
lookup another field for another calculation, so that's not really an
option
either.

Any suggestions on where else to look? This punctuation thing has got me
beat.

Thanks

Hi,

[quoted text clipped - 24 lines]
Thanks, but I now have #Name? displayed in unitCost field. Do you
have any
other suggestions please?

--
Please Rate the posting if helps you

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200709/1