Locating true/false record

  • Thread starter Thread starter DRyan
  • Start date Start date
D

DRyan

Hi, I am currently having a problem gettting a true/false
value from a table based on the values in the two other fields.
My three fields are in the table are client names, boxno, missing
(which is true/false). I have a combo box with clients names which
after update affects a list box contents (box no). Sometimes this list
box contains more than one value (a client may have >1 file). Depending
on which value of this box the user clicks on, I want the database to
tell me whether or not this file is missing (ie true / false for that
particular record).
Please help!
 
DRyan,

One possible approach to this would be via a domain aggregate function.
You could put an unbound checkbox on the form, and set its Control
Source to something like the equivalent of...
=DLookup("[missing]","YourTable","[client names]='" & YourCombo & "' And
[boxno]=" & YourListbox)
(assumes boxno is a number)
 
Back
Top