G
Guest
Hi all,
I've constructed a form for the purpose of amending member details for our club. A list box has been inserted and a macro written with the FindRecord command. I've attached the macro to the listbox but it refuses to find the record as it should. When I click on a member number in the listbox all it does is change the member number on the form but it doesn't bring up that members details.
For example - Member no. 1 shows on the form when it is opened. The list box shows in the upper-left of the form. When I select member no. 7 in the list box, member no. 7's record is meant to display. Instead, all the details of member no. 1 remain but the member no. field is changed to 7. So member no. 1 now displays as member no. 7.
I'm using the book 'The Smart Guide to Access 2000' and have copied the macro from p. 228.
Can anyone help?
I've constructed a form for the purpose of amending member details for our club. A list box has been inserted and a macro written with the FindRecord command. I've attached the macro to the listbox but it refuses to find the record as it should. When I click on a member number in the listbox all it does is change the member number on the form but it doesn't bring up that members details.
For example - Member no. 1 shows on the form when it is opened. The list box shows in the upper-left of the form. When I select member no. 7 in the list box, member no. 7's record is meant to display. Instead, all the details of member no. 1 remain but the member no. field is changed to 7. So member no. 1 now displays as member no. 7.
I'm using the book 'The Smart Guide to Access 2000' and have copied the macro from p. 228.
Can anyone help?