Miscrosoft Access Cant Find The Field "|" referred to in your expression.

[musclemilk]

Good day,

now i know that someone was having the same error message and i read the thread but didnt help me out too much!

so basically i have a command button that on a form that needs to open another form and give me the details of the current record that was selected on the previous form.

here is the code i am using:

Private Sub ouvrir_détails_location_Click()
On Error GoTo Err_ouvrir_détails_location_Click
 
    Dim stDocName As String
    Dim stLinkCriteria As String
 
    stDocName = "Formulaire Locations"
    ' Nom du formulaire qui sera ouvert par le bouton  "Voir Détails Location"
 
    stLinkCriteria = "[NoLocation]=" & [Sous-formulaire Clients]![NoLocation]
    ' Attribution de la valeur active du champ "NoLocation" du "Sous-formulaire Clents"
    ' au champ du même nom dans le "Formulaire Location", qui sera utilisé comme
    ' critère de recherche
 
    DoCmd.OpenForm stDocName, , , stLinkCriteria
    ' Recherche effectuée dans le formulaire ouvert en rapport au critère établi précédemment
 
Exit_ouvrir_détails_location_Click:
    Exit Sub
 
Err_ouvrir_détails_location_Click:
    MsgBox Err.Description
    Resume Exit_ouvrir_détails_location_Click
End Sub

any help would be very appreciated
thanks in advance

[MMcCarthy]

What is the data type of [NoLocation]?

Does the form open OK if you remove the criteria?

[musclemilk]

What is the data type of [NoLocation]?

Does the form open OK if you remove the criteria?

the data type of [NoLocation] is Autonumber and the form opens up just fine
when removing the criteria.

thanks for responding so quickly.

[MMcCarthy]

the data type of [NoLocation] is Autonumber and the form opens up just fine
when removing the criteria.

thanks for responding so quickly.

OK one more question.

Is [Sous-formulaire Clients] the name of the current form or another open form?

[musclemilk]

OK one more question.

Is [Sous-formulaire Clients] the name of the current form or another open form?

its the name of the subform within the current form.
the record thats to be selected for the information is in the subform within the current form.

i hope im making sense...

thanks again

[MMcCarthy]

Try this ...

stLinkCriteria = "[NoLocation]=" & Forms![MainFormName]![Sous-formulaire Clients].Form![NoLocation]
 

Substitute the name of your main form for [MainFormName]

Mary

[musclemilk]

Try this ...

stLinkCriteria = "[NoLocation]=" & Forms![MainFormName]![Sous-formulaire Clients].Form![NoLocation]
 

Substitute the name of your main form for [MainFormName]

Mary

Thank you so much for all your help its finally working now!
again thank you! great website!

[MMcCarthy]

Thank you so much for all your help its finally working now!
again thank you! great website!

You're welcome.