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

Requery Combo Box Clears All Combo Boxes

P: n/a
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
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
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.

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.