Hi there
I have a form that lists people. Each field has a click event that opens a people detail form using docmd.openform "PeopleDetail", , ,"str(PeopleCode = " & str(Form!PeopleCode). The detail form opens but always displays the first people record. PeopleCode is an AutoNumber, hence the str(). All tables are linked. Can anyone help? I've used this technique in other forms and it works (even in the same database).
Thanks
I have a form that lists people. Each field has a click event that opens a people detail form using docmd.openform "PeopleDetail", , ,"str(PeopleCode = " & str(Form!PeopleCode). The detail form opens but always displays the first people record. PeopleCode is an AutoNumber, hence the str(). All tables are linked. Can anyone help? I've used this technique in other forms and it works (even in the same database).
Thanks