Paul
|
| Posted: 02/25/2002, 6:11 AM |
|
I have an admin form that allows users to enter a new job vacancy, this form includes a checkbox that gives the option 1=perm job 0=temp job
If the job is "perm" then the user must enter a "per annum" - fldsalary
If the job is "temp" then the user must enter a "per hour/day" - fldpay_rate
What i would like is for the "pay_rate" text field is available to enter into and the salary text field isn't, but if they then check the temp/perm checkbox (i.e. make vacancy a "perm") then the "salary" field becomes available and the "pay_rate" field becomes in-active....
I really need help with this.... thanks in advance
Paul
|
|
|
 |
Ken Hardwick
|
| Posted: 02/25/2002, 7:06 AM |
|
I would suggest another form field where they would
indicate the rate of pay for the person.
Then in the before insert event and the before update event.
check the value in the job type..then populate the correct
payfield.
fldPayField is new field on form but not a field in table
if fldJobType = 1 then
'for perm job
fldSalary = fldPayField
fldPayRate = ""
else
'for temp
fldPayRate = fldPayField
fldSalary = ""
end if
|
|
|
|
|
