By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,657 Members | 774 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,657 IT Pros & Developers. It's quick & easy.

Form fields lock after update in combo box

P: n/a
Hi,

I have a form (with 4 subforms) which is filtered by 3 combo boxes.
Upon loading the form, the form populates fine.

After the first combo box, the form works fine.

After the second one , all 4 forms are correctly populated yet 2 of the
4 subforms' records cannot be modified.

After the third, 3 of the subforms cannot be modified.

Any ideas?

Feb 22 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I Guess I should include more information.

The 3 combo boxes are unbound and populated using a select query on the
box's rowsource.

The 4 subforms are bound each to a different table.

The combo box's afterupdate event uses this code to bookmark the forms
record...

If Not IsNull(Me.cmb_NewSelectIntroducer) Then
'Save before move.
If Me.SubForm_NewContact.Form.Dirty Then
Me.SubForm_NewContact.Form.Dirty = False
End If
'Search in the clone set.
Set rs = Me.SubForm_NewContact.Form.RecordsetClone
rs.FindFirst "[introducer] = """ & cmb_NewSelectIntroducer &
""""
If rs.NoMatch Then
MsgBox "Not found: filtered?"
Else
'Display the found record in the form.
Me.SubForm_NewContact.Form.Bookmark = rs.Bookmark
End If
Set rs = Nothing
End If

Feb 22 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.