Hi.
I'm trying to display result of a query in a textbox on a form and I'm hitting a wall.
I've got 2 tables - Test & Tracker joined 1-to-1 on SerialNo and SN.
table Test already has values inputed for field SerialNo and Tracker.
On the form (working on Tracker table) after inputing the serial number access automatically goes to next record (tracker field is not on the tabbing list).
What i want is on AfterUpdate event for Serial_No for a query to be run in Track_No. Query looks in "Test" table, in column SerialNo, for a value matching that one inputed in Serial_No TextBox, takes Tracker value from that record and inputs it into Track_No TextBox.
Private Sub Serial_No_AfterUpdate
Track_No = "SELECT test.Tracker FROM test WHERE (test.SerialNo="Serial_No");"
End Sub
But it doesn't want to work
And please don't laugh, I'm really crap in that kind of programming
I'm trying to display result of a query in a textbox on a form and I'm hitting a wall.
I've got 2 tables - Test & Tracker joined 1-to-1 on SerialNo and SN.
table Test already has values inputed for field SerialNo and Tracker.
On the form (working on Tracker table) after inputing the serial number access automatically goes to next record (tracker field is not on the tabbing list).
What i want is on AfterUpdate event for Serial_No for a query to be run in Track_No. Query looks in "Test" table, in column SerialNo, for a value matching that one inputed in Serial_No TextBox, takes Tracker value from that record and inputs it into Track_No TextBox.
Private Sub Serial_No_AfterUpdate
Track_No = "SELECT test.Tracker FROM test WHERE (test.SerialNo="Serial_No");"
End Sub
But it doesn't want to work
And please don't laugh, I'm really crap in that kind of programming
