i have one more doubt can i use the dlookup () function to check out three fields
if the same account information and amount are entered within the past seven days
of the current date an error message should come up
If Not is null (DLookup("[amount]", "tbltest", "[amount]= " & Me.amount & " and [account] =" & Me!account))...
jamesjohn
Last Activity: Nov 21 '07, 12:59 PM
Joined: Oct 31 '07
Location:
-
dlookup() using three field in it
-
validationa list box and user input sequence filed
hi to all, this my new post , and i am beginner to access
i am currently facing a problem , i have 2 fields in the a form
( the fields belong to the same table )
field 1 is a list box called [country] and contains a list of country names
field 2 is [number] which is user input
and i cant put a primary key for [number] since a particular country can have numbers from 1 to 40etc
for eg...
No activity results to display