problem in search record

[woody]

Hello ,
i'm still beginner with access 2007 , i just do this project , in attachment

i have problem in search in forms (follow-up , contacts list )

please anyone can fix it for me and tell me what was the wrong.

Thanks a lot.

 

[Trevor G]

Welcome to the Forum,

What seems to be the problem and what do you want it to do?

I added a record and searched whith your control and it worked to filter the record?

 

[woody]

Thank you for your replay,
yes i already add text-box with button to search .
its working in Customers List , but not work in Contacts list and follow-up forms

please can you help me how to fix the problem in that two forms.

 

[Trevor G]

On your contact form your macro is pointing to the Customer List the same as on your main form, you have to change the Search criteria to the Contact as you are searching for contact (I pressume as it is the contact form), you would then have to do the same for the Follow-Up form.

I would consider converting the cmdGo macro to VBA so you can have code behind the button that way it will give you Error Handling.

 

[woody]

Hello ,
sorry dear but i don't know how to change that pointing form ... can u explain me more details.

im still beginner

thanks

 

[woody]

please if u can fix it for me and upload it.