Select values

[Maailmapoiss]

When I choose value into a combobox, which is related to table Kin. Then it should change in this form App fields like that
Kiri=Nimi
Mak=Maks
KE=KE
Vaar=VaarID
Nimi,Maks,KE, VaarID are from table Kin.
The problem is that sometimes I don't need automatic information from table Kin and that time I fill fields Kiri, Mak, KE, Vaar, by myself.

Thanks for your answers.

 

[SQL_Hell]

Aye?

What exactly is the problem? I can't make much sense of this

 

[Maailmapoiss]

Problem is that I want to make bill form, which gets sometimes information from confirmation form, sometimes I have to just type in the information.

 

[Maailmapoiss]

My code right now is like this:

Private Sub KinnituseNR_Change()
Dim A As Integer
Dim StrSQL As String
A = [KinnituseNR]
StrSQL = "Select [Kinnitus].KinnituseNR, [Kinnitus].UNimi From [Kinnitus] WHERE [Kinnitus].KinnituseNR = A"
Me.Kirj = StrSQL

End Sub

 

[SQL_Hell]

Ok I understand a bit better now.

So if you select from the combo box list then you would like the code to execute.

If you do not select from the list then you would not like the code to execute.

Is this right?

 

[Maailmapoiss]

Yes, that's correct.
But this code doesn't give me the UNimi value to the field Kirj. It gives there value - Select [Kinnitus].KinnituseNR, [Kinnitus].UNimi From [Kinnitus] WHERE [Kinnitus].KinnituseNR = A

 

[SQL_Hell]

Try changing the bound column on the combo box to 2.