code error is calling a form

[Jen0dorf]

Hi

yet another head banger problem

in the attatched datbase if I open the form frm_westbury

then press the button "All Baptisms"

my results form appears

If I click on a the Surname field then a details form appears

All perfect.

This code works

Private Sub Surname_Click()
DoCmd.OpenForm "frm_WestburyBaptismDetail", , , "BirthID = " & Me.BirthID
End Sub

If I return to the opening form and press the All marriages button

then my results form appears

If again I click on the Surname hyperlink

I get a perameter box appear.

I've compared the code between the two forms and see nothing wrong

THis code does not work

Private Sub Surname_Click()
DoCmd.OpenForm "frm_WestburyMarriageDetail", , , "MarriageID = " & Me.MarriageID


End Sub[/CODE]

Can some nice person take a look


thanks

Ian

[cyanidem]

There's no [MarriageID] field in qry_WestburyMarriageDetail. Simply add it in query design.

[Jen0dorf]

Hi

many thanks - egg on face, just goes to show a fresh paor of eyes works wonders

cheers

Ian