Refresh form based on field value

[reglarh]

I have a club member table that has entries for both husband and wife, with separate member numbers. Each entry records the member number of the other half of the couple. When in a form that displays one of the couple, I want to click on the partner number field and refresh the form with the partner details.

I can't see how to do this. My attempts at using a macro reassigning the member number to the partner number only produces a blank form.

Any ideas?

 

[Ranman256]

you can change the record on the detail form

sub btnJump_Click()
me.Filter="[id]=" & me.PartnerID
me.FilterOn  = true
end sub

 

[reglarh]

Thanks, so simple!