how to open a form base on query

[kitaeshi]

Hi all, how do u open a from with a set query to show those tat u wanna see.

 

[dealwi8me]

You can create and save the query, and then use it as recordsource of your form (instead of using a table as record source).

The problem is that you can't change the data of a record source based on a query.

 

[missinglinq]

Amazingly, I've based my forms on queries for years and they're updatable! The fact of the matter is, most experienced developers will tell you not to base a form on a table, even if only one table is invovled, but rather a simple query based on the table! It all depends on the type of query, with most simple Select queries being updatable.

Here's a small article from Allen Browne explaining why some queries are read-only.

http://allenbrowne.com/ser-61.html