I have a table [Invoice Overview Data Table] which has a field [Open/Closed]
in it.  This overview Data Table holds the general information about the data
I am collecting on costs of an invoice.

Then I have another table that collects the cost data of the invoices and
this table is called [Invoice Data Table].

The two tables ([Invoice Overview Data Table] and [Invoice Data Table]) both
have common fields called [Invoice Number].

I'd like to use DLookup to get the value for [Open/Closed] in the [Invoice
Overview Table] and place it in a query based on [Invoice Data Table]. I.e. I
want to pull the [Open/Closed] value for the Invoice numbers that match among
[Invoice Overview Data Table] and [Invoice Data Table].

When I use DLookup now, it returns the first [Open/Closed] value for all the
records.  It does not appear to be looking at the invoice numbers, matching
them and then selecting the [Open/Closed] value.

Here is the code I used:
Open/Closed: DLookUp("[Invoice Overview Table]![Open/Closed]","[Invoice
Overview Table]","[Invoice Overview Table]![Invoice Number]=[Invoice Number]")

Is there another function I should be using?

I would appreciate any help on this.

Thanks.

Ebitari