Form View of Query

scarlo

Registered User.
Local time
Today, 17:41
Joined
Jun 10, 2005
Messages
18
I would like to run my query, but have it open into form view- any suggestions?

*I don't want filter by form, or query-by-form, I want the info that would come up for the query, "MsterQry1", to be shown in the form. Thx~
 
Create a new Autoform: Datasheet based on this query.
 
Well I was hoping to use an already constructed form, but this will work I guess. Thanks a lot ;)
 
You can use the form you created as a subform on your other form, if you'd like.
 
Well, the issue is that my boss wants the "add client" form to be (or at least look) the same as the query-driven form... It would allow ease of browsing and editing for particular Project Managers over their records.

The form you suggested, the one I've created and which is driven now by the query- doesn't have the drop-downs that the "add client" form does, nor does it contain "Holiday Gifts" (since that item is contained in a seperate table and is not included in the query currently).

Is there any way to drive the original form by my special query? Perhaps I could copy it and with the 2nd copy change the source directly to the query? Sorry if these are simple questions- I didn't know anything about Access a couple months ago but was taken on a summer internship and dedicated to this project (by myself)- so, it's been a bit of a struggle at times ;).

Thanks again for your help.
 
I guess I'm not really sure how to respond to your question. A Form can be based on any recordset you choose (a table, a query, etc.). It is basically a "window" to the underlying recordset. It allows you to interact with that data in different ways. If you have two fields in two different tables that you'd like to represent on a form, you can create a query to bring these two fields together. You can then create a form based on that query. A common example of this may be in the case of a one-to-many relationships. Say you have a table that holds customer information, with a primary key of CustomerID. You also have a table that holds order information. This table most likely contains CustomerID as a foreign key. If you needed to view the customer name along with order information, you'd have to join these two tables together in a query. You could then base this form on a query.

A form may also have different views. You can create a form that shows one record at a time ("Form View"), or a form that looks like a spreadsheet and displays several records at once ("Datasheet View").

On the form, you can define the controls in any way you want. You can make a textbox that requires the user to type in a value. You could create a combo box that allows the user to select a value from a list. Its all up to you.

I'm not sure if any of this helps or not, but I'm really not sure how to answer your question.
 
Is there a way to define a form I've already developed as a Template, so that when I create my Autoform (to draw data from query) I can use that template?

I'm wanting the form to be based upon the query- yes, but I want the form I've already developed to be doing it- I don't want to develop a new (and elaborate) form.

Sorry for any confusion, hope this clears things up.
 
You can copy the form you've developed and change the recordsource to your new query.
 

Users who are viewing this thread

Back
Top Bottom