Problems with pulling value from Unbound Control in Form Footer.

[MChrist]

I have a query that I'm trying to pull several values from the unbound
controls in the footer of a form. The controls are combo boxes allow for
selection of several different types of associates. The default value of the
combo boxes is set to 1 and I've included setting the combo boxes value to 1
again in the Form Open Event.

I'm using the format [Forms]![fTargeting]![cmbRegionalManagerID] to retrieve
the value from the form, but unless I specifically change the value in the
box, the default value is not pulled in the query, and only a square is
displayed.

Any thoughts?

TIA

Mark

 

[Tom Ellison]

Dear Mark:

I recommend you temporarily put the value from the control in the SELECT
part of the query and see what the query returns. Is it showing "1" as you
expect?

Now change the query to just use 1 instead of the value from the control.
Does the query work correctly with the value 1 hard coded?

My theory is, either the control isn't returning 1, or the query doesn't
work with 1 as you expect it to do. By narrowing the problem, perhaps
you'll see what is causing this yourself. It is hard to see what the cause
is from here.

Tom Ellison