FindRecord macro not finding the record on Amend Member Details form

[Joseph]

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?

 

[Steve Schapel]

Joseph,

I don't have the book you mentioned, so perhaps you could tell us the
details of the macro you are using.

In the meantime, I think the major problem could possibly be that your
listbox is bound to the Member Number field in your table, whereas I
suspect you will probably need an *unbound* listbox for your purpose.

- Steve Schapel, Microsoft Access MVP