D
Dave Ramage
Hello..
I'm haing a problem with a main form/subform arrangement, where after
entering the subform, the main form locks up -i.e. no fields or even unbound
controls in the active record of the main form can be edited.
A few more details....
The main form (frmClaimEntry) consists of various text boxes and is bound to
table tblMain. There is also a four page tab control which acts as a
wizard-type procedure to obtain a final result from various data entered by
the user at each step. The third page of the tab control contains the subform
frm_CalList which has tblVehicleMatch as its record source. This table is
created via ADODB code during the previous wizard step, then the subform
..RecordSet property is set and the third tab page is displayed. The code goes
something like this:
Sub Command_Next_Click
Dim rs As ADODB.Recordset
Select Case Me.Tab1
Case 0
'do some checks
Me.Tab1.Value = 1
Case 1
'do some checks
Set rs = GetSubFormRecordSet 'function that creates new table and adds
'records, then returns
recordset
If rsMatch.RecordCount > 0 Then
Set Me.Sub_CalList.Form.Recordset = rs
Me.Tab1.Value = 2 'show page with subform on it
End If
Case 2
'etc.
End Select
End Sub
This all works fine, and the tab page with the subform is displayed and the
user can browse through the subform records. When they tab out of the subform
however, they can no longer edit the active frmClaimEntry record!
Here is what I've found out so far:
- This also happens even with an unbound subform (i.e.
Me.Sub_CalList.Form.RecordSource = ""). Clicking in and out of the subform
still locks everything up.
- Buttons still work after lockup- it is just text boxes, combos etc that
are effected (even unbound ones)
- Cannot duplicate the problem on a test form with a simila setup.
- The problem can be 'reset' by running this code:
Me!Claim_Key = Me.Text_Claim_Key
(Claim_Key is a field in tblMain on the main subform)
I would be most grateful for any suggestions!
Cheers,
Dave
I'm haing a problem with a main form/subform arrangement, where after
entering the subform, the main form locks up -i.e. no fields or even unbound
controls in the active record of the main form can be edited.
A few more details....
The main form (frmClaimEntry) consists of various text boxes and is bound to
table tblMain. There is also a four page tab control which acts as a
wizard-type procedure to obtain a final result from various data entered by
the user at each step. The third page of the tab control contains the subform
frm_CalList which has tblVehicleMatch as its record source. This table is
created via ADODB code during the previous wizard step, then the subform
..RecordSet property is set and the third tab page is displayed. The code goes
something like this:
Sub Command_Next_Click
Dim rs As ADODB.Recordset
Select Case Me.Tab1
Case 0
'do some checks
Me.Tab1.Value = 1
Case 1
'do some checks
Set rs = GetSubFormRecordSet 'function that creates new table and adds
'records, then returns
recordset
If rsMatch.RecordCount > 0 Then
Set Me.Sub_CalList.Form.Recordset = rs
Me.Tab1.Value = 2 'show page with subform on it
End If
Case 2
'etc.
End Select
End Sub
This all works fine, and the tab page with the subform is displayed and the
user can browse through the subform records. When they tab out of the subform
however, they can no longer edit the active frmClaimEntry record!
Here is what I've found out so far:
- This also happens even with an unbound subform (i.e.
Me.Sub_CalList.Form.RecordSource = ""). Clicking in and out of the subform
still locks everything up.
- Buttons still work after lockup- it is just text boxes, combos etc that
are effected (even unbound ones)
- Cannot duplicate the problem on a test form with a simila setup.
- The problem can be 'reset' by running this code:
Me!Claim_Key = Me.Text_Claim_Key
(Claim_Key is a field in tblMain on the main subform)
I would be most grateful for any suggestions!
Cheers,
Dave