Access 2003 Edit Record Form (record selection)

I am new to Access and need help creating an edit record form. I've
got a table called Player with attributes like name, address, phone,
etc. I've created an edit player form with a combo box that gets
populated with a list of all the players (run from a lookupplayer
query). When I select a user it gives the unique player ID.

Now my problem, how do I take the unique ID to select that player's
record to edit? The bottom part of the form has text fields for each
of the attributes (name, addr, phone, etc.) that gets its source from
the current record on the Player table.

Any help would on this issue would be great!

Thanks,
Alex

re: Access 2003 Edit Record Form (record selection)

I probably do not have enough information on what your form looks like. But,
the simple way would be to do the following:

1) Create a combo box using the wizard, select the option to look for the
specific record
2) When adding the additional fields, use the tool bar field options to drag
and drop your required fields, this will ensure the records are named
properly.

Give me some more detail to dig a little further.

B

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200702/1