Opening Form with Query
- Thread starter tblues87
- Start date
boblarson
Smeghead
- Local time
- Yesterday, 21:56
- Joined
- Jan 12, 2001
- Messages
- 32,059
Based on your question, I don't think you truly understand what a form is and what a query is.
A form does not store anything. It can be bound to a table or query which then means it DISPLAYS the data and can pass the data back to the table/tables through the bound controls which are bound to fields in the table/query.
A query does not store data either. A query is just a view of data that resides in a table or multiple tables. Some queries can be updatable where you can update the underlying table data directly or through a form which is bound to that query.
So, if you want the data stored in a table, then you can bind (set the form's Record Source property) to the table or query of your choice and then add/edit/delete from the form. To show a completely new record you can either move to a new record or if you want to do it automatically (without showing all previous records entered) then you can set the form's DATA ENTRY property to YES which then it will display only the records currently entered from the current session (time which you have that form open). Closing and reopening the form (or requerying the form) would have the effect of making the form go to a new record and have none of the records currently in the bound table/query shown.
I hope that helps.
A form does not store anything. It can be bound to a table or query which then means it DISPLAYS the data and can pass the data back to the table/tables through the bound controls which are bound to fields in the table/query.
A query does not store data either. A query is just a view of data that resides in a table or multiple tables. Some queries can be updatable where you can update the underlying table data directly or through a form which is bound to that query.
So, if you want the data stored in a table, then you can bind (set the form's Record Source property) to the table or query of your choice and then add/edit/delete from the form. To show a completely new record you can either move to a new record or if you want to do it automatically (without showing all previous records entered) then you can set the form's DATA ENTRY property to YES which then it will display only the records currently entered from the current session (time which you have that form open). Closing and reopening the form (or requerying the form) would have the effect of making the form go to a new record and have none of the records currently in the bound table/query shown.
I hope that helps.
