populating items on a form in VB

[james_skeggs]

Hi,

I have a form in access that i want to populate various fields for.

What i want to do is to write in vb the (i guess sql) statement to pull various bits of data.

ie. I have a table called Introductions.

the primary key is an autonumber called "IntroductionsID"

I want to pull the value of field "ManagerID", "InvestorID" where "IntroductionsID" = me.label45.caption.

Any ideas anyone?

Kind regards,
James

 

[Liv Manto]

docmd.runsql
sql = append query