best way to set up list and detail forms

[csuebele]

I want to set up a database that has a form for listing jobs then another form for the details of that job. I want to be able to do a search in the detail form, go to the list form and have just the records showing that I searched for in the detail form, and then be able to click a button or click on the record and go back to the detail form. What is the best way to set this up? Are the forms based on a table or on a query table. Do you use filters, etc?

 

[GinaWhipp]

What you want is doable but it all starts with the tables. Sounds like you are unfamilar with Access, so I'm going to suggest....

Jeff Conrad's resources page...
http://www.accessmvp.com/JConrad/accessjunkie/resources.html
The Access Web resources page...
http://www.mvps.org/access/resources/index.html
A free tutorial written by Crystal (MS Access MVP)...
http://allenbrowne.com/casu-22.html
MVP Allen Browne's tutorials...
http://allenbrowne.com/links.html#Tutorials
Sample data models...
http://www.databasedev.co.uk/table-of-contents.html

 

[csuebele]

Thanks, Gina. I am unfamiliar with Access. I've been doing some of the Lynda.com training, but there are big gaps in what I see there and what I want to do. I've been using FileMaker for years, but have to switch to Access.

 

[GinaWhipp]

The above should get you started. Once you get the tables set-up post them here and we can tweak them... well, if you want!

 

[csuebele]

The above should get you started. Once you get the tables set-up post them here and we can tweak them... well, if you want!

Gina, I've been looking over the links you suggested - a bit daunting at times. I still haven't found anything that would help with what I want to do. I'm attaching my database (there might be some unnecessary stuff in it, as I was trying different things. What I would like to do is to be able to do a QBF on my frm_MainEntry and then be able to click on the button "Log List" that takes me to the form: frm_ListView, and have the same QBF apply to it. With the frm_ListView, I can then quickly browse for other found items, click on a record on that form, and it will take me back to the frm_MainEntry form for further editing. Any help on how I can set this up or a better alternative would be greatly appreciated!!!

Chuck

 

[GinaWhipp]

I will be looking at this a little later...

 

[GinaWhipp]

I think this is what you want...