>I have employee database in MSAccess namely "Emp.mdb" with five fields namely 1. Empid 2. Name 3. Designation 4. Basicpay
>5. DOJ(date of joining). In VFP I have designed "Employee.SCX" in that i put five text boxes namely 1. txtempid 2. txtname 3. txtdesignation 4.txtbasicpay 5. txtDOJ. and one command button namely "cmdget".
>
> I have entered any of the empid in txtempid and click the getcommand button the records of empid will dispaly corresponding text boxes.
>
>How to wite the code?

Check classes referenced in Re: Reading a MDB database Thread #1379510 Message #1379519