My database is a single table of business contacts. Records are added through a form with fields for company, address, contact name etc. If I query the table for all companies in certain area for example, is it possible to output the results to a form with one contact per page instead of the normal table?

Thanks
Chris

Hmmmm....you're asking if you can get your query results put to your form instead of opening as a 'datasheet' query?

Sure. Are you trying to use the same form as you use to enter, or does it have stuff you won't need to just view? If you design a new/similar form and base it off of your query for the area, you can pull up just the records you want in a Form. You can do the same with your existing Form but I'm not sure how much I'm going to confuse you if I tell you how.

Post back if you need further assistance,
David R

Thanks Dave

[This message has been edited by ChrisBray (edited 04-10-2002).]