<div>
Private Sub Form_Load()<br />
&nbsp; &nbsp; With Data1<br />
&nbsp; &nbsp; &nbsp; &nbsp; .DatabaseName = App.Path &amp;&nbsp;&quot;\abd.mdb&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; .RecordSource = &quot;SELECT * FROM TheTable;&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; .Refresh<br />
&nbsp; &nbsp; &nbsp; &nbsp; .Recordset.MoveFirst<br />
&nbsp; &nbsp; End With<br />
End Sub<br />
<br />
Private Sub Data1_Validate(Action As Integer, Save As Integer)<br />
&nbsp; &nbsp; Text1 = Data1.Recordset.Fields(0)<br />
&nbsp; &nbsp; Text2 = Data1.Recordset.Fields(1)<br />
&nbsp; &nbsp; Text3 = Data1.Recordset.Fields(2)<br />
End Sub<br />
<br />
<br />

</div>


Private Sub Form_Load()
    With Data1
        .DatabaseName = App.Path & "\abd.mdb"
        .RecordSource = "SELECT * FROM TheTable;"
        .Refresh
        .Recordset.MoveFirst
    End With
End Sub

Private Sub Data1_Validate(Action As Integer, Save As Integer)
    Text1 = Data1.Recordset.Fields(0)
    Text2 = Data1.Recordset.Fields(1)
    Text3 = Data1.Recordset.Fields(2)
End Sub




<div>
JOHNHO,<br />
<br />
You should accept (or reject) someone's answer or comment - thanks is not enough &nbsp; ;-)<br />
<br />
<br />
SLE
</div>


JOHNHO,

You should accept (or reject) someone's answer or comment - thanks is not enough   ;-)


SLE

<div>
same as above<br />
<br />
except that<br />
after connecting to database<br />
<br />
'****<br />
set text3.datasource = MyRecordSet<br />
<br />
text3.datafield=&quot;FieldName<wbr />GoesHEre&quot;<br />
<br />
<br />

</div>


same as above

except that
after connecting to database

'****
set text3.datasource = MyRecordSet

text3.datafield="FieldNameGoesHEre"




<div>
<div class="content wysiwyg-content">
like this i has 1 data control in my form and 3 text box.<br />
<br />
i want to connect the data control to abc.mdb <br />
and inside the abc.mdb therea 2 table<br />
and i want to connect that data control to abc.mdb withe the table no 2 and also inside that table i has 3 field.<br />
so i want my 3 text box to become that 3 field.<br />
<br />
i know i can do it in the properties windows. <br />
<br />
but now i want to do it manually in the code .<br />
<br />
how ?<br />
<br />

</div>
</div>


like this i has 1 data control in my form and 3 text box.

i want to connect the data control to abc.mdb 
and inside the abc.mdb therea 2 table
and i want to connect that data control to abc.mdb withe the table no 2 and also inside that table i has 3 field.
so i want my 3 text box to become that 3 field.

i know i can do it in the properties windows. 

but now i want to do it manually in the code .

how ?



how do i set the database ?

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.