Making it possible to click and view selection

[resolva]

Hi all,

I am currently in the process of developing a database. Really simple, basically I have made a table called "Project" and a form for this table where users can insert details on a new project.

Basically now I want to display all these projects on a "view projects" form.

What is the best way of doing this? All I require is the project title and the batch number to be shown in a list on the view projects page and then be able to click on which one to see them.

Thank you in advance

Aaron

 

[pbaldy]

The simplest way would be a combo or list box. If you want to open another form with the selected item:

http://www.baldyweb.com/wherecondition.htm

 

[resolva]

Awesome, that helps me out a lot. I will simply link the selection with the form I wish to open.

Just while im here, say you have data from one form which a user has filled in. How do you then display some of that data in part of another form without subforms? Is this possible?

 

[pbaldy]

Is the data related to the data in the form you want to display it on? If so, you may be able to base the form on a query that gets all the data. If not, you may be able to use a DLookup() or something.