Hello all,

I am not an experienced Access user and this is my first time in a
newsgroup but I have two difficulties with Access.
First let me explain what I have:
I have a database with contacts (persons) which is quite large. The
table (and form) has multiple textboxes/inputs like name, address etc.
Besides this form I also have a form for an actionlist (what to do
this week). This uses a subform with actions ("to do") and checkboxes.
Each week I want to make a new list (new record).

My problems are:
1. I want some kind of search for my contacts. Therefore I placed a
textbox (TextSearch) at the bottom and want someting like this to
happen when I push a button:
WHERE (((Contacts.NameCompany) Like [Forms]![Contacts]![TextSearch] &
"*"))

But I don't know how to do this in Visual Basic...

2. For the actionlist I want to show all "old" actions in a new record
(BeforeInsert?) if the checkboxes are not checked. At this moment when
I create a new record it shows no actions.

Can someone please help me and send me an e-mail?

Thanks,