Well after playing around with this a bit, I found a way to do it. But
it's not pretty...
Basically, I put a text box covering the comboBox field so that just
the drop down arrow is showing and then enter this code in the text
=DLookUp("FieldName","tblxx","[IDFieldName] = " & Nz([IDFieldName],0))
This seems to work, but is kind of messy and the performance isn't
great. It takes a split second to populate the fields if the user
scrolls the continous form real fast. Also, since I locked the text
box, the user can no longer just edit the field but rather is forced
to use the drop down arrow. That takes a little bit out of the
Anyone got another way of doing this?
On Fri, 10 Nov 2006 17:23:32 -0500, Sierras < XXXX@XXXXX.COM >