reference combo box value (1 Viewer)

Brian Martin

Registered User.
Local time
Today, 06:28
Joined
Jul 24, 2002
Messages
68
I want the full description text box to pickup the value from cboPress. I don't want the user to have to click on it though. I have tried using the selected property but couldn't quite get it to work. How can i achieve my aim?
I have attached my example
 

Attachments

  • test.zip
    56.2 KB · Views: 75

Jon K

Registered User.
Local time
Today, 06:28
Joined
May 22, 2002
Messages
2,209
Change the Control Source of FullDescription to:-

=cbo2.column(1) & " " & cbo3.column(2) & ", " & DLookUp("Pressure","QryPress")
.
 

Brian Martin

Registered User.
Local time
Today, 06:28
Joined
Jul 24, 2002
Messages
68
Thankyou!!!

Fantastic!! I've spent all morning trying to work that out. You've made my day and helped set me up for a good weekend. Thankyou!!
 

Users who are viewing this thread

Top Bottom