Expand|Select|Wrap|Line Numbers
- Private Sub cboID_VU2_Change()
- Me.[Vlasnik.ID_VU].Value = Me.cboID_VU2.Column(0)
- Me.[Naziv tvrtke].Value = Me.cboID_VU2.Column(1)
- Me.[Ime korisnika].Value = Me.cboID_VU2.Column(2)
- Me.[Prezime korisnika].Value = Me.cboID_VU2.Column(3)
- Me.[Adresa korisnika].Value = Me.cboID_VU2.Column(4)
- Me.[Telefon].Value = Me.cboID_VU2.Column(5)
- Me.Mail.Value = Me.cboID_VU2.Column(6)
- End Sub
Expand|Select|Wrap|Line Numbers
- SELECT Vlasnik.ID_VU, Vlasnik.[Naziv tvrtke], Vlasnik.[Ime korisnika], Vlasnik.[Prezime korisnika], Vlasnik.[Adresa korisnika], Vlasnik.Telefon, Vlasnik.Mail FROM Vlasnik ORDER BY Vlasnik.[Prezime korisnika];
Me.[Vlasnik.ID_VU].Value = Me.cboID_VU2.Column(0)
with message "You can't asign value to this object"
I thinks the problem is that Vlasnik.ID_VU is autonumber.
This is how the form looks like : https://i.stack.imgur.com/LqDt3.png
This is how relationships are set up : https://i.imgur.com/4lsigWB.png