Dlookup works in form, but not in subform.
Importing text into Access Report - SQL - Programming::
14 postsYou can't have the form save into a memo field in a particular record in a . Don't allow additions or deletions to the subform to ensure there's only one
http://forums.whirlpool.net.au/forum-replies-archive.cfm/424505.htmlHOME |
In the form called Item Subform , I have a combo box that uses both fields from the table L-Property-ClassList (see below). The name of the combo box is PropertyClassNumb (I made it different from the field name in the table for my own clarity).
I have a text box on the form Item Subform that is called PropertyClassDesc (again, I made it different from the field name in the table for my own clarity).
In it’s Control Source I have:
=DLookUp("[L-Property-ClassList].[PropertyClassName]","L-Property-ClassList","[L-Property-ClassList].[PropertyClassNumber]=" & [Forms]![Item Subform]![PropertyClassNumb])
Table L-Property-ClassList
PropertyClassNumber (primary key number) 1,2,3,etc
PropertyClassName (text) Currency, Jewelry, Motor Vehicles, etc.
When I open Item Subform , the PropertyClassDesc displays perfectly. When I change PropertyClassNumber, the PropertyClassDesc updates correctly.
Referencing controls in Access subform not working?? - Tech ::
12 posts - Last post: Feb 9, 2007Another alternative that I have used is to save the Combo selection in a "Dummy" table and use Dlookup in the Query Criteria row.
http://forums.techguy.org/business-applications/528790-referencing-controls-access-subform-not.htmlHOME |
Next, add Item Subform as a subform to another form called Incident. When I open the form Incident (with Item Subform as it's subform), PropertyClassDesc shows only #Name? in the subform area.
Thanks in advance to anyone who can help.
 I Am a Sinner – What About You?
 Global Sourcing and Supplier Online by Dylan
|
Dlookup--Can it be used in a subform?