button specifc record

[tubar]

i would like to create a button on a form that will open another form and a specific record...like record 19...if u tell me a code....i could write in record 19....

 

[KeithG]

First you need to create a form and base it off a parameter query. Then create your button and add the below code

docmd.openform [FormName]

 

[CEH]

The above code will get your new form open, but not to record "19"
There's more than one way to do this.... But try just a pop up box first to enter your record number..... In your criteria for the second form... you should have a field named "record" or something like that.... In the criteria put [Enter Record Number] ....... This will create the pop up to enter your record number after you press your command button.
You could also have a unbound text box on the first form to enter the number and have your criteria refer to that..... Post back if you want to do that... I'll tell you how.... Little more lengthy...

 

[KeithG]

The above code will get your new form open, but not to record "19"

You will be prompted for the record number if you base your form on a parameter query like I said to.

 

[CEH]

Keith....... I wasn't sure he would know he needed something in the criteria to make it a parameter query

 

[RV]

If record 19 is in the current form, simply add a button to the form and follow the wizard.
The wizard will provide you with a choice to open the other form for a specific row.

RV