Dlookup problem

cie00011

New member
Local time
Today, 07:30
Joined
Apr 26, 2006
Messages
9
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
 
=DLookUp("Load",[Forms]![Main_Screen]![Project_Name])

But no it only displays the first data point of the series, how do i get it to display all the series?
 

Users who are viewing this thread

Back
Top Bottom