I have a Form displaying data in textboxes from a table - table has too many colums ...., but the Autonumber field I havr named "UNIQ" (to remind me ..). The Table is set as a RecordSource for the table.
In order to select which record is displayed, I created a Combobox with a Query, Selecting only 3 fields from the table - Name, Description and UNIQ.
The combo box shows only Name.
When Selecting a Name from the Combo, I have the code :
DoCmd.SetFilter , "UNIQ = " & Me.cboxName.Column(2)
Everything works perfect for the records - I can browse thogh all one by one, but
Problem!?!:
The changee of cboxName changes the recorded Name in the Table !
Example:
I have 3 records:
Labels: UNIQ Name Description P1 P2 etc ...
1 Sec1 Content 100 45
2 Sec2 Content 65 21
3 Sec3 Content 121 45
Record 1 shows correctly, but after I select Record 2, the table content changes to:
Labels: UNIQ Name Description P1 P2 etc ...
1 Sec2 Content 100 45
2 Sec2 Content 65 21
3 Sec3 Content 121 45
and if I continue Sec 3 also changes ..
Can someone explain why is this happening and how can I avoid it?
regards