ActiveX and Databases

[Sash]

I'm trying to get a string value from a prompt in an ActiveX control I recently created to use in another form.

I just can't seem to get the value though - how do I link the activeX to the other form?

Frustrated,

Sash

[crispin]

can you not reference the property in the ActiveX control, i.e. MyNewValue = Control.Property1??

post some source code Sash (if you've got any)...

[Sash]

Thanks for that, I couldn't find anything about retrieving values from an activeX control in any of the VB books I had.
Typical!!

My script is simple, and I'm not a great VB programmer but I am trying to learn. If you know a better way of doing this please tell me.


Option Explicit
Dim filepath As String
Dim file As String
Dim entirepath As String

'Getting a value for a path from a path chooser form.

Private Sub Dir1_Change()

File1.Path = Dir1.Path
filepath = File1.Path
Text1.Text = filepath

End Sub

Private Sub Drive1_Change()

Dir1.Path = Drive1.Drive

End Sub

Private Sub File1_Click()

file = File1.FileName
Text1.Text = filepath & "\" & file

End Sub

Private Sub UserControl_Initialize()

Text1.Text = Drive1.Drive

End Sub