Field Display goes Blank

[iamnu]

SELECT zDepartments.DeptID, zDepartments.DeptName,
zDepartments.DirectoryID
FROM zDepartments
WHERE (((zDepartments.DirectoryID)=[Forms]![PhoneBook]!
[PhoneBookSubForm]![cboDirectory]))
ORDER BY zDepartments.DeptName;

The Subform in DataSheet view allows me to select the appropriate
DepartID based on the DirectoryID selected. When I select a DeptID
and display the DeptName, all is well.

But when I move to the next record, the DeptName is STILL displayed
correctly, but the DeptID goes Blank (appears empty), but when I go
back to that same record, the proper value still exists.

Can someone explain what's going on?

 

[Jeanette Cunningham]

Hi iamnu,
this does happen when using a subform to filter the main form.
Here are a couple of links that explain it and a work around.

http://allenbrowne.com/ser-28.html

http://allenbrowne.com/casu-20.html


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia