DLOOKUP issue

[gemadan96]

I have a form for Registration Details based on my Registrations Extended query. I've placed an unbound control in the form header. I want it to return the name of the tournament associated with the open registration. In the detail area of the form is a control for the tournament called TID that comes from the Registrations Extended Query. It is not visible in form view.



I have set the Control Source for the unbound control as follows:

=DLookUp("Tournament Name","Tournaments Extended","TID =" & [TID])

This returns #Error so obviously I'm stating the criteria incorrectly.

Any suggestions?

[pbaldy]

The names with inadvisable spaces in them likely need to be bracketed. You're treating TID as a numeric data type; is it?

[gemadan96]

I modified the query name and the field name to remove the space then modified the epression to:

=DLookUp("TournamentName","TournamentsExtended","T ID=" & [TID]) and now it works.

TID is a numeric data type.

Thanks.

[gemadan96]

I also have a split form called Registration List. It has a button to select a saved filter to show. The filters are saved in a table named filters.

I would like to do something similar and display the name of the filter in the form header. I've started with this:

=DLookUp("[Filter Name]","Filters","ID=" & [ID])

The problem is there is no control on the form to identify the active filter ID. Can I create a control on the form to identify the active filter? I would be setting its visible property to no.

The Select Filter button has an embedded macro that runs code that is in a saved macro.

[pbaldy]

You're applying a filter to the form? It should be available in code:

Me.TextboxName = Me.Filter

[gemadan96]

It's a split form with a datsheet on the bottom. It lists all the registrants. It has a button control to select saved filter. The filters can be used to view all registrants for a particular event or the user can save a new filter after they have filtered the data to their liking. It came from the Asset Management template available from Microsoft.

[pbaldy]

Not familiar with it, but did you try using the Filter property?

[gemadan96]

Not sure where to enter the filter property.