Group:  Microsoft Access ยป microsoft.public.access.modulesdaovba.ado
Thread: Filling in a forms text boxes using ADO??, HELP!!

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Filling in a forms text boxes using ADO??, HELP!!
"Jason" <none[ at ]none.invalid> 01.03.2006 21:39:23
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.



Re: Filling in a forms text boxes using ADO??, HELP!!
rexecampbell[ at ]yahoo.com 01.03.2006 21:56:45
http://www.asp101.com and you will find tons of code to help solve your
problem.

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net