Drop Down Box only works once

[Robert_L_Ross]

Not sure what I've managed to do, but maybe someone can help.

I have a form I use to select records for audit. This form displays the
transaction type that then can be audited for multiple scenarios.

When the user selects the record to audit, it opens a new Audits form and
pre-loads some data (user, date, etc.). During this 'pre load' of data, I
set a combo box source values to only allow the audits that pertain to the
transaciton (2 columns, 1st one is the text description, the 2nd is the
value, bound to 2nd column).

After the user selects the audit type, they click a button to load the
quesitons for that particular audit and continue on their way - the whole
time the audit type drop down box shows the text description of the audit.

Now, when you open the form to just look around and the completed audits,
the drop down box appears blank (even though I know there is a value there).
I set up a new text box and set the source to the same field the drop down
box has and the number identifier appears.

My question is, why when I first load the form and select the audit, the
text identifier appears while it stores the number in the source field (runs
as expected), but when I open the audits form without 'preloading', neither
the text identifier or the numeric value appears? How do I fix this, or can
I have another field that displays the text identifier that can refresh every
time the user moves records (maybe a dlookup or something)?

Any help is greatly appreciated!

Rob

 

[Klatuu]

It is possible that when you set the combo box source, it will not display
because it is restricted to the previous transaction. Try resetting the
source in the After Update event of the form. As to reopening the form and
it does not work (if I understand properly), it could be that you are closing
the form with acSaveYes. This will cause the form to open with the combo box
restricted.

I don't know that this is the answer, but it is certainly a place to look.

 

[MacDermott]

A combobox will only display a value in the "textbox" portion if that value
corresponds to an item in the drop-list.

You mentioned that you set the items in the drop-list as part of your
"preload" process.
If you bypass that preload "just to look around", are you loading any items
into the combobox's rowsource? If not, nothing will show in the textbox
portion.

HTH