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?
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?