A
alhotch
I have a Combo Box on a form by the name of DNTReason. The Control Soucre for
this CB is =DLookUp("[DNTReason]","[DNTReason]","[DNTReason.DNTReasonID] =
" & [DNTReservations.DNTReason]) . This works as advertised returning the
value (text data) from the [DNTREASON].[DNTREASON] "table.field".
Now remember, this is a Combo Box. What I would like to do is use this Combo
Box to change its value from what the DLookUp reported to some other value in
the underlying table. Since DLookUp has already given me the value of the
Combo Box, clicking on the "down arrow" of the Combo Box will display
available values from the DNTReason table but I can not select any data. The
form just "beeps" at me.
I tried to put the DLookUp in a macro annd change the Control Source back to
DNTReason but it gets confused. Any ideas as to how I can use DLookUp to
"prime" the field but yet, let me change its value through the Combo Box
"down arrow" ?
this CB is =DLookUp("[DNTReason]","[DNTReason]","[DNTReason.DNTReasonID] =
" & [DNTReservations.DNTReason]) . This works as advertised returning the
value (text data) from the [DNTREASON].[DNTREASON] "table.field".
Now remember, this is a Combo Box. What I would like to do is use this Combo
Box to change its value from what the DLookUp reported to some other value in
the underlying table. Since DLookUp has already given me the value of the
Combo Box, clicking on the "down arrow" of the Combo Box will display
available values from the DNTReason table but I can not select any data. The
form just "beeps" at me.
I tried to put the DLookUp in a macro annd change the Control Source back to
DNTReason but it gets confused. Any ideas as to how I can use DLookUp to
"prime" the field but yet, let me change its value through the Combo Box
"down arrow" ?