Soundsmith
Programmer
I have a form whose job is to display matching results in two subforms (three tables, the form holds a master table, when I move from record to record, the subforms show matching results from the other two tables.)
Everything works fine when I use the nav buttons or record selector. WEhen I use the combo box, the proper subform records show up, but the main table does not follow (the nav counter shows 1, and data in record 1 is partially replaced.)
The combo has two fields, monrLink and caseLink - caselink is the visible one, monrlink is the actual matching field.
The matching field is monrLink, the combo box is cboMLink, the table is tblMONRActive.
I know this is pretty simple, but I can't get them to sync.
the combobox code is:
In the cbobox after_update event, I have tried:
This displays the data, but alters the first record in the tblMONRActive rather than move to that record. I'm not using recordsets here, and would prefer to keep it that way.
Thanks for any help.
David 'Dasher' Kempton
The Soundsmith
Everything works fine when I use the nav buttons or record selector. WEhen I use the combo box, the proper subform records show up, but the main table does not follow (the nav counter shows 1, and data in record 1 is partially replaced.)
The combo has two fields, monrLink and caseLink - caselink is the visible one, monrlink is the actual matching field.
The matching field is monrLink, the combo box is cboMLink, the table is tblMONRActive.
I know this is pretty simple, but I can't get them to sync.
the combobox code is:
Code:
SELECT [tblMONRActive].[monrlink], MID([tblMONRActive].[monrlink],3,7) & "-" & RIGHT([tblMONRActive].[monrlink],2) AS caselink FROM tblMONRActive;
In the cbobox after_update event, I have tried:
Code:
Private Sub cboMLink_AfterUpdate()
' move to selected record
Dim newMonr As String
newMonr = Me.cboMLink.Column(0)
DoCmd.FindRecord (newMonr)
Me.Requery
End Sub
This displays the data, but alters the first record in the tblMONRActive rather than move to that record. I'm not using recordsets here, and would prefer to keep it that way.
Thanks for any help.
David 'Dasher' Kempton
The Soundsmith