Open Form / If not / MsgBox

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

I want to use the data in the unbounded text-field [Search] to open
Form “fruits†and find a record in the control [apples] with an
Msgbox “no records found†if no records were found. In that case the form
should not open…

Should I look in the table “fruits†or in the form “fruitsâ€..or ???

Thanks for all help!
 
Sounds like you need to do a Dlookup against the table/columnn to decide
whether to open the form or not.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
Back
Top