@@@ Need Help @@@

[¦ê¨ì·ô]

Table A has fields : staffname, currentbasicsalary
Table B has fields : staffname, year, month, basicsalary, bonus

Form C is created for inputing the year, month, basicsalary and bonus and
to calculate the salary of the staffname.

Question:
How I can set the default value of basicsalary equal to the
currentbasicsalary of that staff?

 

[Steve Schapel]

¦ê¨ì·ô,

Make your Form C based on a query that includes both tables, joined on
the staffname field from both tables. In the AfterUpdate event of the
staffname control (combobox?) on the form, use code like this...
Me.basicsalary = Me.currentbasicsalary