sql in ms access

[ritu]

can i use sql procedures and functions in ms.access instead of making
programmes in visual basuc, as i have no idea to do programming in visual
basic, as i have two forms one is main form and the second is the sub form i
wan to populate sub form on the basis of the the value in one of the combo
box list from the main form , both forms r linked, eg i have employee table
and managers table i wan to pick one manager name in main form and wan to c
all the employee working under that manager and all this should be in the sub
form.
pls help me and pls give me fuul details, i m new user so pls help me
plssssssssssssssss

 

[aaron.kempf]

this would be pretty simple to do using an access data project

i reccomend setting it up as a form and a subform and using
'linkmasterfields' and 'linkchildfields' to managerid

-Aaron

 

[Sylvain Lafontaine]

The first thing to do would be to ask in the right newsgroup. This one is
about ADP and SQL-Server and not really about the use of SQL in a MDB file.

You should ask your question in the m.p.formscoding, m.p.a.modulescoding or
maybe in m.p.a.queries.