Include data from unbound table

[JHNielson]

This seems like such a simple question, and I thought I knew how to do it, but I can't get it to work.

I have a form that is bound to a table 'ETL" and users can enter data into that form.
I want at the top of that form to include teh build number a value form another table "Version-Table"

I put a text box in with a link to a query (SWB - DLU Version Number) that finds the maximum number in that version table.

I put the control source as:

=[SWB - DLU Version Number]!MaxOfDLU_Version

But when I open the form all i get is a "Name?" in the box.


I also have a report I am creating and trying to do a similar thing, and it gives me the same problem.

Any help would be greatly appreciated.


Thanks

[Rabbit]

You have to use:

DLookup("[Field Name]", "[Table/Query Name]", "Where Clause")

The "Where Clause" is a filter criteria built like the SQL Where clause but without the WHERE.

[JHNielson]

You have to use:

DLookup("[Field Name]", "[Table/Query Name]", "Where Clause")

The "Where Clause" is a filter criteria built like the SQL Where clause but without the WHERE.

Thanks for the help. I just have another question...

So for he Where "Clause" do I need to include the query information or can i just call on the query I already have defined?

Also, would I do the same thing for the report?

[Rabbit]

You can't call a query for the Where clause. It's there to specify which record you want to return. If there's only one record then there's no problem. Otherwise you have to tell it which record to return by saying something like "[ID] = 4".

Yes, it would be the same for the report.

[JHNielson]

Great - got it to work

Thanks!

[Rabbit]

Not a problem.