Open Form / If not / MsgBox

[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!

 

[Dorian]

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".