how to create SQL string

[jerry28ph]

Hi,

Just want to ask anybody how can we write an SQL string to run a subform. Correct me if I'm wrong, subform is one way how to view of query results on your main form, but how can we run a query (with user criteria that can enter only in main form) that when you click a command button the result will save to table. Sorry if I mixed up my question, I just a newbie in Access and want to learn about SQL.
Thanks

 

[MSAccessRookie]

First you need to define a query that retrieds the data that is to be the basis fot the new SubForm. Once you have done this, if you can go to Design Mode, you can create a new form that is based on the query by using the Form Wizard, and then add the new Form as a Sub-Form to the existing FOrm. Of course, you will need to establish the relationshops between the Form/Sub-Form before you can take advantage of them.