Employee info in Payroll form

[ismalee]

Dear All.

I am Ismail , new in MS access,

i have made a database for my company that include emplyee Information EmployeeName, ID number ,Salary basic , housing, telephone , in TBEmployee and etc,..

my manager now need to add Payroll in same database. so i have made a table for payroll called TBpayroll with Name, ID number ,Salary basic , housing, telephone, OT, OTTravel, Leavepay, Airfair .

I have made a Form FrmSalary that bounded to TBpayroll with all field.



My Question : Can i get vallues in FrmSalary text field Salary basic , housing, telephone from table TBEmployee by selecting EmployeeName combo box.

Please give me a solution,

[pbaldy]

Welcome Ismail. Is this what you're after?

http://www.baldyweb.com/Autofill.htm

[replicant00A52]

@pbaldy regarding the link you provided above (I am also new to access 2007). What if the customer table has thousands of names and a drop down is not practical. I have been trying to figure out how to build a customer order form that will function as follows:

- search CustomerTable
- auto fill form with details from CustomerTable
- search ProductsTable
- auto fill form with details from ProductsTable (price etc.)
- do some basic accounting calculations (price X quantity etc.)
- make a new record in the SalesTable (Customer A purchased product B for X amount on specified date)

is this even practical / possible in access I have scoured the web and not found a good implementation of such an access form.

Thanks

[pbaldy]

Not sure why a combo wouldn't be practical, as the user can still type in values. You can also do this:

http://allenbrowne.com/ser-32.html

[replicant00A52]

good point on the combo box. The coding in your link is way over my head. John Galt is a character from an Ayn Rand Novel (Atlas Shrugged, I think)