Control Source

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have an 'Accurals' form to track sick time, vacation time, etc. There
are combo boxes to change the amount of time an employee gets bound to a
field in the tAccurals table. But the catch is that each year employees get
more time. Is there a way to make a controls control source a field with
conditions? IE FieldName "SickTime" but year 2005.

Table fieldnames are: (AccuralID, EmpID, Year) <-- Primaries and then
SickTime, VacationTime, Sick1..., Vac1...

Thanks,
Ernst.
 
Where do you keep the amount of time an employee gets for each type of time
by year?

If you have fields in your table something like this, it will be pretty
simple:
Time_Year
Time_Type
Time_Value

Then filter your combo box on Time_Year and your are done!

If you don't have that table structure, then I suggest you add it.
 
Where do you keep the amount of time an employee gets for each type of time
by year?

If you have fields in your table something like this, it will be pretty
simple:
Time_Year
Time_Type
Time_Value

Then filter your combo box on Time_Year and your are done!

If you don't have that table structure, then I suggest you add it.
Click to expand...

Ok... In my tAccurals there is Time_Year, Time_Type, and Time_Value, as well
as DateValue. I have 4 comboboxed. 1. For the Year, 2,3,4 for the amount of
sick, vacation, and personal time one is allowed to take. The a text box for
each date that they are allowed to take. Everything works great until I
incorporate the year filter on the controls... The comboboxes need to lookup
the allowed time for the cYear.value but if one changes this value it then
needs to update the database... I can use a lookup to assign the value to the
combobox but I cannot reverse it.. withoug assigning its control source to a
field... Cannot do this with the condition of year...

Ernst.
 
Back
Top