Query from access 1

[falled]

How can I exxecute a Query in access

I've got to relationed tables, and on a form I've got a comboBox with values of one field of a table.

I've got a label too.

I want to implement combobox_change, when it changes, put on the label the value of the other table which is relationed.

I hope you have understood me

B happy!

 

[PHV]

You may consider the DLookUp function.
Another common way is to already have the info in the combo and use the Column property.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[falled]

Private Sub CodiPlanol_Change()
   Dim varX As Variant
   Dim varY As Variant
   varY = CodiPlanol.Value
   MsgBox (varY)
    varX = DLookup("[Description]", "Planol", "[Id] =" & varY)
    MsgBox (varX)
End Sub

What I'm doing wrong???????

Divided by 0!

 

[PHV]

What is the SQL code of CodiPlanol.RowSource ?
What is the value of varY ?
Which line of code raises the error ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[falled]

Sorry

Table Planol(Id, Client, Description)

Codiplanol is ComboBox, with the Id.

I want that when CodiPlanol changes Show on a label the Description.

varY is the current value on the combobox, the msgBox are only to see if I'm catching the information I want.

Here is the error:

varX = DLookup("[Description]", "Planol", "[Id] =" & varY)

 

[PHV]

I asked what is displayed in the msgbox ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[falled]

The ID of the planol

 

[PHV]

I asked about the VALUE physically displayed in the box.

 

[falled]

Ok is Text, 50 chars long

sorry, I hope you refer to this

 

[PHV]

So, you may try this:

varX = DLookup("Description", "Planol", "Id='" & Replace(varY, "'", "''") & "'")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[falled]

Your are a genius!!!!!!

What was wrong?? why replace function!?

 

[PHV]

What was wrong
Id is defined as text in Planol, so you need to surrond the literal value with single quotes.

why replace function
To quote any single quotes in the value of varY

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886