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,