Make sure the folling code is in a module, not a form

Code:
Private Type BoatInfoType 
  MooringNumber As String 
  BoatName As String 
  BoatLength As String 
  OwnerName As String 
  OwnerAddress As String 
  OwnerTelNo As Integer 
End Type 

Public boatinfo As BoatInfoType
When the user clicks on a boat i assume you know which boat it is.

Lets say they click on boat 1.

Get the information from the database for boat 1.

now store that info into "boatInfo"

Code:
boatInfo.MooringNumber = database.mooringNumber
boatInfo.BoatName = database.boatName
etc.
now bring up the information form and display the data.

Code:
  frmBoatInfo.Show
Now in the form load event of the information form display the data.

Code:
  Private Sub Form_Load()
    Text1.Text = boatInfo.MooringNumber
    Text2.Text = boatInfo.BoatName
    ...
  End Sub

Is this helping you at all?