> I am building a personal databse to keep track of all of my roleplaying
> characters. I borrowed the phone book in the northwind sample database and am
> modifying it for my purposes. I wish to be able to click on a character name
> in the phone book/directory and the form to modify that character's
> ingormation will open with the character loaded into the form. Any
> suggestions on how to do this?
Add the ID field to the record as an invisible text box, then use the
Double-Click event of the name text box to add a bit of code like:
DoCmd.OpenForm "YourFormName",,,"ID=" & Me.txtID
> Also, I would like to dynamically change the field that the alphabet option
> group filters by command buttons at the bottom. Basically, if I click on a
> button that says "frist name" then when I click on the 'B' filter button the
> directory will be filtered by first name. If I click on the button "last
> name"... you get the picture.
You'd have to rewrite the Option Group macro as code, using an If ... Then
statement that would choose the first name from a toggle button. You could
also copy and paste the macro to a new name and just use a bit of code to
choose which macro to run.

Signature
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
Damon - 17 Oct 2005 23:18 GMT
Thanks very much for your help. I got both options working, great help!
Damon
> > I am building a personal databse to keep track of all of my roleplaying
> > characters. I borrowed the phone book in the northwind sample database and
[quoted text clipped - 22 lines]
> also copy and paste the macro to a new name and just use a bit of code to
> choose which macro to run.