Query to look like a form

[Lyncroft]

Probably quite an easy one this but how can you make the results of a query look like a form as opposed to normal datasheet view.

Thanks in advance

 

[Hayley Baxter]

Hi Dominic

This maybe isn't what you want but you can create a macro and choose to open the query in print preview mode, this makes the results of a query look like a report. Maybe someone else knows other methods?

Hay

 

[Rich]

Create a form with the query as its record source, which is the correct way to enter / view data anyway

 

[Hayley Baxter]

I think this is the Query by Form sample that I sent to Dominic where whatever is chosen in the form is displaying the results in the query. You can do this so they are not displayed in the query but displayed on another form or a report which is the way I have done it. Just cahnge the coding slightly.

Hay

 

[b9791]

Probably quite an easy one this but how can you make the results of a query look like a form as opposed to normal datasheet view.

Thanks in advance

You do it the same way that you would do it for a table. The form would be bound to the query instead of a table.