Update Form & Combobox Issues

[MarkMcAllister]

Greetings,
I'm having an issue with two similar forms which change the status of Instructors and Students from 'Atcive' to 'Inactive' with a checkbox, See attached Form Issue ZIP file.
Whenever a student's or Instructor's status is changed, the name is written over with the table's ID number.
I've tried several times to modify both the form and combobox's data tab properties, but I can't seem to get it right.
Any help is appreciated.
Mark

[CJ_London]

duplicate post here

http://www.access-programmers.co.uk/...=1#post1429984

[MarkMcAllister]

duplicate post here

http://www.access-programmers.co.uk/...=1#post1429984

This is cross posted here:
http://www.utteraccess.com/forum/ind...0#entry2539421
and here:
http://www.access-programmers.co.uk/...d.php?t=277799
Thank you CJ_London for setting me straight.

[CJ_London]

Looks like UA have provided answers so I would stick them - they are giving good advice.

[MarkMcAllister]

Greetings all,
tina t on utteraccess http://www.utteraccess.com/forum/ind...howuser=178721 said it clear enough for me to understand.
Make the combo box unbound, and then add code in the After Update event to point to the record to be modified.
After further digging, I found some references to the Combobox wizard to point to a specific record.
I created a new form and set its source to one of the tables. Made a combbox with the wizard and got the code

    ' Find the record that matches the control.
    Dim rs As Object


    Set rs = Me.Recordset.Clone
    rs.FindFirst "[Student_ID] = " & Str(Nz(Me![Combobox_Name], 0))
    If Not rs.EOF Then Me.Bookmark = rs.Bookmark

After renaming the unbound comboboxes, the code was placed in the proper place.
Now, both forms work as expected.


From this point on, I will try to be as possible, and if I cross post, will clearly indicate with the appropriate links.
With gratitude,
Mark