Right.
Assuming you can get all of the data out of the database.
Create a user define type. Then create an array of this type. Lets say you have 4 boats.
Place the following into a module. eg. boatModule. This way you will be able to access the data from any form
Code:Priavte Type BoatInfoType Name As String Cost As Double End Type. Public boatInfo(3) As BoatInfoType
When you get the data from the database put the information on each boat type into your User Type.
Code:For i = 0 To 3 boatInfo(i).Name = "Name Of Boat From DataBase Record i" boatInfo(i).Cost = "Cost Of Boat From DataBase Record i" Next i
Then when a user click on a boat you should know what number the boat is and do the following.
Hope this helps.Code:txtBoatName.Text = boatInfo(boatNum).Name txtBoatCost.Text = boatInfo(boatNum).Cost




Reply With Quote