Yup!

I've got two popup forms called from buttons on the rows of
a continuous subform.

With Marshall Barton's help, over in forms.coding, I've been
trying to get textboxes to look like buttons, but change
color when the forms that they would pop up have one or more
records for the current subform record.  When I add one of
the tables that would feed one of the popups, and give it an
outer join, all is well.  But when I add the second table
into the frey, the subform won't let me add any records.  I
really don't want to have a separate form for edits or a
whole bunch more code than I can remember what it's for...),
if I can avoid it.  It wouold be very nice for the
data-entry folks and for the checkers, to be able to see on
the form/subform which records already have data that would
show in the popups.

Outside of that route, I've been trying to get DLookup to do
something for me.  First, I it in the conditional formatting
boxes, then I tried in the RecordSource for the "buttons".
But either I'm not getting the syntax right, or I'm trying
to do things that are out of logic.

Aha!  I actually tried that in one of my zillions of "try
this" attempts, but probably had the rest of it hosed in
some fashion.

Another thought I had was to put the DLookup in the
RecordSource for the textbox masquerading as a
commandbutton, and then do the conitional formatting on the
results.  Somehow, that seems a little cleaner to me, but my
poor memory for syntax (and much else) has me mired in the
muck.

Thanks for the hint!