How To Go From One Form to Another

[Carlnlola via AccessMonster.com]

I have a form that displays names and contact information. It is based off a
master table (called CONTACTS). It uses a combo box to look up and display
the contact ifo for whoever I select from the list.

In order to simplify any search process, I also have simple forms that
consists of a list box. Each form is specific to a particular region within
the state (based on queries). What I want to do from any of these forms is
double-click on a name in the list and have the original form (described
above) load and display the record for that name.

Any suggestions will be great.

-Regards, Carl (if there's any level below NOVICE, I'm it)

 

[Amy E. Baggott]

Easiest way is to set the On Double-Click event to

DoCmd.OpenForm (formname, , , "ID = " & me.ID)

Using your form's name, the name of the ID field on the form you're opening,
and the name of the field you're double-clicking, since I assume you are
using the contact ID number as the bound column for the list box.