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

[Guest]

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.

 

[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
(e-mail address removed)

 

[StopThisAdvertising]

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

--
==>Let's ask it the 'nice' way...
Would you please, please go away Steve ??

This is to inform 'newbees' here about PCD' Steve:
http://home.tiscali.nl/arracom/whoissteve.html (updated, mainly the 'abuse-reporting' page...)
Until now 3700+ pageloads, 2375+ first-time visitors
(these figures are real and rapidly increasing)

Why is this ???
Because Steve is the ONLY person here who continues to advertise in the groups.

It is not relevant whether he advertised in *this* particular post or not...
==> We want him to know that these groups are *not* his private hunting grounds!

For those who don't like too see all these messages:
==> Simply killfile 'StopThisAdvertising'.
Newbees will still see this warning-message.

ArnoR

 

[Guest]

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.

 

[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