Access, look up forms

Dear Helen

Thank you for attending Access Intermediate course!! I hope you enjoyed the course and benefited from it.

Your question is quite interesting one. Normally if you just wanted to see the results of users input you would create a parameter query and then create a form based on that parameter query.

You can create a parameter query and then convert that parameter query into a make table query which would give you the desired result. But there is a slight problem with this. Because you cannot have two tables with the same name when you run the make table query for the second time and enter a new criteria it will override the records from the new table.

I would strictly recommend you to create a simple parameter query and then create a form based on this parameter query. Once you have done so when you run the form you will be asked to put the criteria. Enter the criteria and you should be able to view only the records that match the criteria as a form. Choose File> Save As and then give appropriate name to the form. You can create many forms like this by putting different criteria.


I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007