extracting data from fields in access onto vb forms

[SueS]

I have a student who has set up a database with access 2000 for an assignment. One table called products has a field called ProductName and another called UnitPrice. She has set up a form with an array of check boxes and she would like the caption of each check box to be a productName from the file and next to each a textbox or label which will display the corresponding UnitPrice of the item. Anothe text box will enable input of quantity of each item. The user will then check which items they want to purchase and vb will calculate the total amount.

Is there a simple way that the files can be read into the vb?

[honeybee]

Check out database programming in VB elsewhere on VB World, mostly at http://www.vbworld.com/databases/dbtutorial/ That should get you started on the interaction between Access and VB.

.