Help | Site Map
Connecting Tech Pros Worldwide
 
 
LinkBack Thread Tools
  #1  
Old February 22nd, 2006, 06:05 AM
flamethrower01@gmail.com
Guest
 
Posts: n/a
Default Form fields lock after update in combo box

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?

  #2  
Old February 22nd, 2006, 10:05 PM
flamethrower01@gmail.com
Guest
 
Posts: n/a
Default Re: Form fields lock after update in combo box

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

 

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over network members.
Post your question now . . .
It's fast and it's free

Popular Articles