Combo Box Question

[Terrence Carroll]

I have a question about combo boxes. I have a form based off of a query to
return or show all records with certian criteria in the form selected or
where nothing has been selected in the combo box. When I select criteria in
the combo box and then switch it back to blank the combo box appears to be
retaining the original value I selected and therefore not showing up on the
form. How do I fix this issue?

 

[Jeff Boyce]

Terrence

How are you doing this? What code/macro do you have in place that causes
the form to return a specific record based on the combobox selection?

How are you switching the combobox "back to blank"?

Is the combobox unbound, or do you have it bound to a field in the
underlying query?

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Terrence Carroll]

Hi Jeff,

Thanks for the helping hand. Right now I have a lookup table for Audit
Results, i.e. bill rates match, bill rates do not match, and pending - No PO
to audit yet. This helps serve a reporting purpose as I need to indicate how
many audits have been complete and when they have been completed along with
an aging. I have a form that is based off of a query to return all records
with a null value or "pending - No PO to audit yet" in the Audit Results
combobox. The data in the combo box also drives an audit date field. If the
Audit Result is bill rates match or bill rates do not match the audit date
filed is populated with the current date. The problem that I have is that
when a user selects a value in the combo box (i.e. bill rates match, bill
rates do not match, or pending- No PO) and tries to turn that value back to
blank, the query that pulls the data on the form still reads the value of
Audit Results to be the value selected (i.e. bill rates match, bill rates do
not match, or pending- No PO) and not blank. Therefore the select query that
comprises the records pulled up on the form does not pull the record that was
originally blank then changed a combo box value, and then changed back to
blank. This is important since I have users relying on the data on the form
to be their work list for the week. Any help you could provide would be much
appreciated.

Thanks,

Terry Carroll

 

[Jeff Boyce]

Terry

Your description tends to focus on the form ... but in Access, it all starts
with the data. How you do something depends on what data structure you're
using.

Please describe your underlying table structure in more detail ... that's
where the data actually lives, not in the forms...

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[De Jager]

I have a question about combo boxes. I have a form based off of a query to
return or show all records with certian criteria in the form selected or
where nothing has been selected in the combo box. When I select criteria
in
the combo box and then switch it back to blank the combo box appears to be
retaining the original value I selected and therefore not showing up on
the
form. How do I fix this issue?