I have a database with 2 tables. One table is the specifics for a person. The other table is for tracking incidents with these people. I have a form (frmEdit)that has a combo box with the person's ID in it and you select the ID and the form should populate with the data on that person. The first problem I have is I use this code to update the form:
Me.RecordsetClone.FindFirst "[ID] = " & Me.cmbCDC 'Combo box with ID
Me.Bookmark = Me.RecordsetClone.Bookmark
rs.FindFirst "[ID] = " & Me.cmbCDC
rs.MovePrevious ' I had to put this in because it was always one item forward of the data
'The next code enters the data tothe form from the recordset.
txtName = rs.Fields("Name")
txtEthnic = rs.Fields("Ethnicity")
txtDOB = rs.Fields("DOB")
txtFBI = rs.Fields("FBI")
txtCII = rs.Fields("CII")
txtCommit = rs.Fields("Comm Offense")
If you select the first Person in the list, the form populates properly. If you choose any other person you get an error that the value entered is not valid for this field.
The next problem is that I have a pop up form to add new people to the database. I open the form from a NotInList method from a combo box using this code.
DoCmd.OpenForm "frmAddInmate", acNormal, , , acFormAdd, acDialog
If I open the form from the Access menu everything works fine, Opening it from the entry form it doesn't work. The entry form opens up and the combo box populates properly but when you select a person from the list, I get an error "no current record" error message.
Any suggestions?
Me.RecordsetClone.FindFirst "[ID] = " & Me.cmbCDC 'Combo box with ID
Me.Bookmark = Me.RecordsetClone.Bookmark
rs.FindFirst "[ID] = " & Me.cmbCDC
rs.MovePrevious ' I had to put this in because it was always one item forward of the data
'The next code enters the data tothe form from the recordset.
txtName = rs.Fields("Name")
txtEthnic = rs.Fields("Ethnicity")
txtDOB = rs.Fields("DOB")
txtFBI = rs.Fields("FBI")
txtCII = rs.Fields("CII")
txtCommit = rs.Fields("Comm Offense")
If you select the first Person in the list, the form populates properly. If you choose any other person you get an error that the value entered is not valid for this field.
The next problem is that I have a pop up form to add new people to the database. I open the form from a NotInList method from a combo box using this code.
DoCmd.OpenForm "frmAddInmate", acNormal, , , acFormAdd, acDialog
If I open the form from the Access menu everything works fine, Opening it from the entry form it doesn't work. The entry form opens up and the combo box populates properly but when you select a person from the list, I get an error "no current record" error message.
Any suggestions?
