Connecting Tech Pros Worldwide Help | Site Map

Requery Combo Box Clears All Combo Boxes

 
LinkBack Thread Tools Search this Thread
  #1  
Old November 13th, 2005, 11:36 AM
Budinski
Guest
 
Posts: n/a
Default Requery Combo Box Clears All Combo Boxes

I have a subform that has a datasheet in it.
In the datasheet I have multiple records.
Each record has many textboxes and combo boxes.
I have a particular combobox with 2 columns, Column 1 has the ID,
Column 2 the description (The ID is hidden) (We will call this combobo
cmbDescription).
The combobox in question is dependend on a different combobox in the
record (we eill call this combobox cmbCriteria)
When I enter the cmbDescription I have some Code that goes like this.

If Not IsNull(fldCriteris) Then
GlobalCriteris = fldCriteria
cmbDescription.Requery
End If

The cmbDescription uses the GlobalCriteria (i relize there is a better
way but I have been tinkering with this for a while so it has changed
over time) to filter what descriptions are available.

When this happens it effects all the combo boxes above it in all the
previous records and clears the combo box of its description but the ID
is there but the description disappears.

It only happens to this combo box because it has 2 columns and the
second column (decription text) doesn't have a match when using the
globalvariable I have been having many troubles since I can't figure
out for the life of me how else to give the criteria to the query with
a if in place (if null). Otherwise I would just reference the
fldCriteria directly.

I really need some help and can't figure it out.

Thank you in advance.
Bud


 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

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 220,840 network members.