combobox not displaying results

[bpauley]

Hello All,
I have a form to gather visits for a therapy staff, behind the form is
qryEnterVisits. I am using 3 combo boxes to set the criteria for 2 other
combo boxes.
I am using parameters based on the first 3 combo boxes in the last two combo
boxes, however I don't get any results.
When I open the querys for these last 2 combo boxes alone, the parameter
pops up and I enter the criteria for each and receive the desired results
displayed by the query. There are 3 parameters.
Can you point me in the correct direction? The combo boxes that are not
working properly do NOT have column heads set to yes. The bound column is 0
for both and the three parameters are in the order they are entered in the
2nd, 3rd and 4th cols in the query grid. Don't know if that matters.
Thanks
Bill

 

[Jeanette Cunningham]

Hi Bill,
check all the settings for the combos-->
the no. of columns
the column widths
the correct column in the query is set as the bound column for the combo
Also temporarily set the width of the bound column to 0.5" and check the
results.
The name of the query in the combo's row source.
If this doesn't help, consider that the form is becoming corrupted.

Here is one fix from a poster called CrazyAccess-->
I've learned that sometimes I can fix a corrupted form simply by renaming
the form, then renaming it back to its original name. For me, this resolves
form
corruption I'd say about 50% of the time.

Here is a link to corruption tips:
http://allenbrowne.com/recover.html


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[bpauley]

Hi Jeanette,
Thanks for the quick response. I have already checked all of the criteria
you listed. But I will go back thru it slowly to make sure it is all set
correct. The read the post from CrazyAccess prior to your recommendation. I
did that but it did not work. I actually renamed the form and compacted the
db and then renamed it back and it did not fix it. I will post back after
retrying the list below. Thanks for the link to Allen Brown's corruption
tips, I will check them out.
Bill