I have two forms one displaying data for a single record. Within this form there is a combo box, the data source being another table. I want to be able to click a button on the first form that will read the value of the combo box and display the relevant record on the second form I am currently using:

DoCmd.OpenForm "Invent_Frm", , , "NAME = " & Me.Name

When I run this the message comes up 'Enter Parameter Value' I have got this method working on a continuous form the only thing I can think of is that the NAME field is not the key field but it is set not to allow duplicates.

Any help would be greatly appreciated!

Simon

For the button's On CLick event, you need to add code that looks like this:

==================================================
Private Sub btnYourButton_Click()
On Error GoTo Err_btnYourButton_Click

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "frmYourFormName"

    stLinkCriteria = "[PrimaryKey]=" & Me![cboYourComboBox]
    DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_btnYourButton_Click:
    Exit Sub

Err_btnYourButton_Click:
    MsgBox Err.Description
    Resume Exit_btnYourButton_Click

End Sub
================================================

Once you have the combo box on your form, if you use the button wizard, it should prompt you to open the new form based on some link criteria anyway.


mmcdonal

First a comment on mmcdonal and your code. If the name that you're searching is text, i.e. type string, then write

DoCmd.OpenForm "Invent_Frm", , , "[NAME] = '" & Me.Name & "'"

Since mmcdonal used SPECIFICALLY [PrimaryKey], which are usually numbers, his is correct assuming [PrimaryKey] is a number. However, you specified NAME which is text, which needs the single-quote delimiters.

As for the "Enter Parameter Value", check to make sure your form is not based on a query that asks for a parameter. In your query's criteria cells, check to make sure you literally don't have

[Enter Parameter Value]

in one of those cells. If you do, that's where that's coming from.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thanks for your input. I looked into it and the Form was looking at a query based form I have found an other way around it.

Thanks

Simon