Cannot Connect a form..help please....!!!

K

khaksar

Hello Every body..

I have a Dat Base with the main table and information table. Then I have
two forms. One is main Form and the other I want to use for search. On the
main table I have a button with the Name " Find Record". now i want that when
i click this button the serch form appears and then ask for the parameters to
search in the main table. But when i click my search b utton it does not call
the search form. Can any one help in these regards.

B sure that i am a new user of Access.

Thanks alot.
Khaksar.
 
S

Steve

Open your main form on design view and select the button. Open properties
and go to the Events tab. Look at the Click event. Click on the three
buttons at the right side of the box. This will either take you to your
existing code or take you through the process of creating code. In either
case you will see the Click event subroutine. The code should be;
DoCmd.OpenForm "NameOfYourSearchForm"

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]
 
K

khaksar

Mr. Steve I tried your hints but it gives problem. Error in the Vb. Can you
please give me your Email ID such that I will mail the whole file to you in
attchment and you will examine clearly.

I will be very thankful to you.

Any body who can helpme will be highly appreciated.

thanks.

Khaksar.
 
J

John Marshall, MVP

Be very careful with sending anything to steve. He will want to be paid for
his time.

Any of te other experts here will do it for FREE>

John... Visio MVP
 
Top