I have a text box on form "Table" and have a combo box on "main"
first the combo box on Main selects the table i want to use "Table1" then i want the "Table" page to display one of the data series "seriesA". I know to use a Dlookup function in the Control Source, but i am having trouble making it work. i have so far
=Dlookup(("[seriesA]", Forms![main]![combo]))
i Also tried
=DLookUp("[seriesA]", " combo", "[combo] = Form![Main]")
As a beginner at access, i have no idea. thanks to anyone that can help
first the combo box on Main selects the table i want to use "Table1" then i want the "Table" page to display one of the data series "seriesA". I know to use a Dlookup function in the Control Source, but i am having trouble making it work. i have so far
=Dlookup(("[seriesA]", Forms![main]![combo]))
i Also tried
=DLookUp("[seriesA]", " combo", "[combo] = Form![Main]")
As a beginner at access, i have no idea. thanks to anyone that can help