Loading a form

[Guest]

Form A is loaded from a switchboad menu. The user can click a letter to view
all vendors whose name begins with that particular letter. The desired
continued functionality is that the user should be able to click on a name,
then click a button to open Form B.

Form B is an existing form where the user can browse through every vendor in
the vendor table, performing edits and deletions as desired. It is accessed
from a switchboard item and works perfectly.

So far, I have the name able to be clicked, I can save the selected name,
but I just can't figure out how to open Form B. Oh, and once I get Form B
opened, I want it pointed to the selected entry from Form A.

Suggestions?

 

[Allen Browne]

You don't need 26 different forms to achieve this.

Open the Northwind sample database.
Open the Customer Phone List form.
It has buttons across the bottom to filter the form to each letter of the
alphabet.

 

[Guest]

I just *knew* that Northwind database hung around for a reason......

Thanks!

 

[Guest]

Actually - I just found a better solution.

DoCmd.OpenForm "frmName", , "Name1 = Name"

Opens the form pointing at the Name.