search criteria on form load

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi , please i am new at programming access and i need some help, i am trying
to get my database to check a table and if the value of a particular filed >
2000 hen i should get a message box . i would appreciate it if you could help
m
 
Use the dlookup for it, to look for a value in a table
The nz will replace the null with 0
If nz(dlookup("Value","MyTableName", "RecordTofind = a value"),0) > 2000 then
msgbox "grater then 2000"
End if
' check help on dlookup and if you need any more help, then we here.
 
Back
Top