multiple tables and data sets in VB Windows app

[shummy1]

I have 6 different tables that need to be used in a windows application. The problems is:

I want to load the combo boxs for some of the fields but once every different box has data chosen I want it to update the dataset for its table as well as the dataset for the table where all completed records are.

A single record will contain information from each of these different tables but gets saved into its own records table.
I have been going around in cirlces with this one. Any direction would be nice.

 

[PCLewis]

I assume you are using Access, so practice using SQL.

DoCmd.RunSql "Update Table1 set Field1=2" for example

Or better still, use
CurrentProject.Connection.Execute if Access 2000 or higher.

 

[xlbo]

VB Windows App" - you do realise this is the VBA forum ???

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[shummy1]

Sorry I did not realize this was the wrong forum.

I am using Microsoft Visual Basic.net but am building a windows application form that uses an access database.

What forum should I be in?

 

[xlbo]

probably the .NET forum - forum796

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question