By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,584 Members | 3,458 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,584 IT Pros & Developers. It's quick & easy.

Access 2003 Edit Record Form (record selection)

P: n/a
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

Feb 26 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Feb 27 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.