Re: Cant figure this out !

Tech-Archive recommends: Fix windows errors by optimizing your registry

Dave,

This is not clear. You're mentioning show but at the end where you say what
you think you need, it seems that you're assigning a value to the property
instead conditioning it. Please re-estructure it and I'll be happy to help
you


--
________________
German Saer
gsaer@xxxxxxxxxxx
Orlando, FL

"Dave Elliott" <mynotebook@xxxxxxxxxxxxxx> wrote in message
news:vxaOe.147872$gL1.4216@xxxxxxxxxxxxxxxxxxxxxxx
> I have a form named Time_Hours with a combo on it that looks up the
employee
> In the criteria of the control (status) in the query it has this code
> [Forms]![frmAutoPayrollReport]![Status]
> This means that the combo list for the employee will only show active or
> archived employees depending on the status selected via the criteria used
> via the main form, I need for it to show all records
> Normally the whole form of which Time_Hours is a sub-form on shows only
the
> records with an active status
> However if the main form is opened with a status of archived then the
> sub-form still shows only archived employees
> and vise versa for the status of active
> If the main form is opened with a status of archived, then I need the
> employee list on the sub-form Time_Hours to show ALL the records for the
> sub-form, active and archived
> The Main form has 2 option buttons on it which are used to to set the
status
> of the whole record.
> Here is what I think I need;
>
> If Forms!TimeCards!Status =1 Then ' this means status is archived
> Forms!Time_Hours!EmployeeID!Status = 1,2 'either active or archived
> End If
>
>
>


.

Quantcast