DLookup :(

[janed]

Another question on DLOOKUP. I want its criteria to be based on two fields on the form, how is this done?

Also does anyone know where i could find a working example this function.

Thanx

 

[DBL]

Don't know if this will help but here is an example of a DLookup that I use on a combo box. It is there to check to see if the candidate has already been entered into the class before the user is allowed continue:

If Not IsNull(DLookup("EDClassID", "tblEntryDetails", "[EDClassID]= " _
& Me![EDClassID] & " AND [EDEntryID] = " & Me![EDEntryID])) Then

 

[llkhoutx]

Look in the Help menu for almost any question that you have,

 

[Pat Hartman]

I would tend to agree with you llkhoutx but help normally only provides the simplest and most useless examples. The help entry for DLookup() is actually more useful than most since it shows three different examples. But, none of them includes multiple fields.