Combo Box Problem

[Guest]

Hi,

I have a subform called "Notes" on the main form "ClaimForm".

In the subform i have a combobox called "code". In this field is staff
member initials e.g MJW
GBE
DAS

I have the following in the row source of the combobox.

SELECT tblStaffCode.* FROM tblStaffCode WHERE (((tblStaffCode.Active)=True));

Basically if the checkbox "Active" is True then only active staff members
initials are displayed in the combobox.

This works perfectly, however if a the "Active" checkbox is false not only
does the staff members not appear in the list which is correct, but it does't
display the staff members initials on all previous records.

The records within the table are un-affected. When i print a report all
information is correct also.

The error only occurs in the subform.

Thanks in advance for any assistance.

GregInOz

 

[Guest]

DISREGARD GUYS - PROBLEM SOLVED.

 

[Isis]

DISREGARD GUYS - PROBLEM SOLVED.

It is really helpful if you post a problem and solve it off group to share
the solution - might save us all some trouble one day.

Well Done solving it.