VB: How to pass the value from one form to another.

Hi All,

I have 2 forms, in one I get the value from the user and when the user presses the ok button , it should open the form 2 (Tabular mode) with the records matching the value entered in the form 1. I am very new to this.

I did like this, If any suggestions Pls send me a code.

docmd.openform formname,acNormal, , , acFormReadOnly, acWindowNormal, value from form1 (parameter).

pls suggest any codes or ideas. very urgent.

thanks & regards
raj

Create a module

Module Module1
Public HoldAnnouncement As String
Public HoldAnnouncementName As String
End Module

On the second form place the code

Public valHoldAnnouncementName As String
Above the Region section

' 'GET THE ANNOUNCEMENT FROM THE FIRST FORM USING MODUGLE 1
valHoldAnnouncementName = HoldAnnouncementName.ToString()
txtAnn.Text = valHoldAnnouncementName
' 'MsgBox(valHoldAnnouncementName.ToString)'TESTING