It sounds as if you need to design a form in continuous view with your query
as the form's record source. Then you open the form (which will automatically
execute the query).

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

lad5ko via AccessMonster.com wrote:
May be I wrote my problem not correctly. I need to display answer from my
query in form view, becouse if I display it in datasheet view every filtered
record have 56 field and i have to use scroll bar to see all fields. I
applied OpenQuery Method (in this method I can not use form view)- may be
another method is better but I do not know it. I am novice in databas design.

Thanks for your time.

PieterLinden wrote:
Not sure what to tell you... you can't view 56 columns of a spreadsheet on a
single screen either, so what makes you think you can do it in a database?

Hi,
Problem :
[quoted text clipped - 8 lines]
lad5ko