Front linked to sub form

[AndyRob1973]

I have built a small data base to track projects that are ongoing.



The main table holds the basic information about the project and then has a one to many relationship to other tables with progress and tasks.

I have already built form which shows each project on its own page with a subform showing the progress and tasks.

However, I would like to build a form which opens first with a spreadsheet type look to it with all the projects listed with the basic details. I would like the ability to search the list based on multiple search fields and then the ability to click on a project to open up the form I have already built.

Thankyou!

[Bob Fitz]

Hmm...Not sure of your requirement. Do you have an actual question or do you just want someone to do this for you.

[Welshgasman]

So create a form for your search fields and a datasheet/continuous form as a subform.
Perhaps a double click on a row opens your form.?

For searching, I always start with http://allenbrowne.com/ser-62.html

[Micron]

Might be easier if the project list was a listbox on that form. You don't want users to be able to edit those records. If you lock the form to avoid that, then you can't select a record. Rather than have a work around for that, just use a listbox and maybe even provide a way to filter it?

[mike60smart]

Hi

All doable

You would have a Form which has a number of Combobox's to display the data you want to search by

This Form would have a Command button which when clicked displays a Continuous Form listing all records which match the Criteria searched for.

You would then be able to click on a specific record which then opens a Form to display that particular records Details.

[AndyRob1973]

Thankyou all.

[mike60smart]

Glad to help