Opening a form with acDialog/query appearing in datasheet view

[michaellysons]

I have a form that I want to open with acDialog (to prevent people interacting with the calling form). The form I open has a button to display the results of a query in datasheet view. The problem is that if I open the form with acDialog, the query results are displayed behind the form and I cannot get to them until I've closed the form.

Is there a way around this? I have tried opening the form without acDialog and this works, but I don't really want to do that if possible.

Thanks.

 

[Mile-O]

Why not put the query as the RecordSource for a subform on your form set to Datasheet view?

 

[michaellysons]

Why not put the query as the RecordSource for a subform on your form set to Datasheet view?

That's a good suggestion, thanks. I'll give it a go and see how it works.

 

[michaellysons]

Thanks again for the suggestion. It worked really well for my needs.