Form , Text box, Button

[amal2004]

Hello

I am trying to create a form with a text box and a button. When you enter a value in the text box like ID Number and click the “Get” button, I need another form to pop up with the info related to that ID.. I really do appreciate any help.

 

[PHV]

Either use Global variable or well known cell.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[VBAjedi]

Here's a little code snippet that puts a value in a global variable, then loads a form and inserts that value into the control. The Global statement needs to be at the top of a normal module (above any subs).

Global StatsRow

Sub DisplayStatsForm()
Dim StatsRow As Integer
Sheets("MarketHistory").Activate
StatsRow = ActiveCell.Row
Load MarketStatsForm
MarketStatsForm.StatsRowBox.Value = StatsRow
MarketStatsForm.GenStatsButton.SetFocus
MarketStatsForm.Show
End Sub

In your case you will want to insert a Find routine where I get ActiveCell.Row to grab whatever information you want from the appropriate row. Load each piece of information into a global variable and pass it to the new form. Alternately, you could just load the form, then put the code that retrieves the values in the new forms Initialize or Activate events (I think you could bypass using the global variables then).

VBAjedi

 

[amal2004]

PHV I am working with access 2000. I need to know what criteria shell i put in the first form and what should be in the open event of the secound form (The pop Up form)....

Thanks

 

[amal2004]

VBAjedi ..
Thanks for your reply... I am sorry if I did not mention that i am using access form the start.. Please can you guide me through making the forms and entering the code, i am a fast Lerner ..
Thanks