Filling in a forms text boxes using ADO??, HELP!!

[Jason]

Hello I have a question for all the experts here.

I've got a table for example Employees with fields like Employee First Name
| Employee Last Name | Address

I have built a form, frmEmployees and have text boxes to correspond to the
fields such as Last Name, First Name. How would I fill those for the
current employee on the form using a module ADO ?

Also on the form I want to put Spouse First Name and would like that to be
filled in as well, this will come from another database called
EmployeeSpouse and I would like to fill in the SpouseFirstName field in
the spouse info table - so that that is also put into this frmEmployees.

now I have opened up that EmployeeSpouse database like this.
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\temp\employeespouse.mdb;"

can someone be of some help and show me how to fill in these text boxes with
data from the table?
thank you.

 

[rexecampbell]

http://www.asp101.com and you will find tons of code to help solve your
problem.