connecting forms to queries

[gibby]

Hello,

I'm new to access, and I've been asked to analyze the structure of a database. In the Access Objects pane, I have a list of tables, queries, forms, reports, and one macro. I would like to know how to figure out which forms are connected to which queries. I figure that when the user hits submit on a form, it must execute some query which places the data filled into the form into a table. Is this right?

I'm using Access 2007.

 

[Simon_MT]

All Forms should be Query bases and if you look at the Form's Properties in Design View look at the Record Source.

Simon

 

[gibby]

Thanks Simon,

I'm looking at a particular form and the query associated with it is a bit confusing. Remember, I'm a newbie at Access so maybe you can make sense out of this for me:

The form *seems* to be one in which the user enters information and then submits to be added to the database (mind you, I don't see a "submit" button, or any button, and I'm not sure if there typically is one that's visible in the design view). The form's name is frmAHSEMSFacilityInformationAdd so I presume its purpose is to added information (on a facility) to the database.

The query that's associated with this form is a select statement that retrieves all the information that would go into the form. This is weird. I would think the statement should be an insert one. It doesn't make sense to query the database with a select statement and then fill in all the form fields with that information if it's an add form.

Is there something I'm missing or is this just a poor/nonsensical design?

 

[Simon_MT]

Check to see in the Form's properties and if there is an Event. It is possible to force a SaveRecord if the record IsDirty.

Simon