A step in my macro is to open a form where the record in the new form will
match the value selected on the first form's dropdown box.  The IDs,
unfortunately, are text and not numeric, so I'm having trouble finding the
right record in the set.

my "where" is:

[customerID] = [forms]![details]![customerID]

but despite my variations in writing this, I get either a type mismatch, or
a new record comes up (though I can see the filter has been applied).

The dropdown box I'm using to select the customerID on the first form does
not
have a control source, though I'm certain it's bound to the correct value
(the ID)
and not the customer name, which is the only other field displayed.

I'm guessing this is just a problem because the equation thinks i'm looking
for a numeric value, but I'm not sure how to put quotes, or whatever, to
indicated the value is text.

Help?!