Unable to populate textbox based on listbox

[marcustofeles]

This was interesting! I just found that if I click (maybe it's an update of the control) the prefix box after the query is run, than it updates the textbox! (the textbox having your original post in this thread as property)

[marcustofeles]

I can't get the DB down to the needed size for uploading.

[Bob Fitz]

I have a copy of your db.

Please try this:

Change the Row Source property of the combo box called "containernummer" to:

SELECT Containers.containernummer, Containers.prefix FROM Containers;

Set the Control Source Property of the text box called "textbox" to:

=containernummer.Column(1)

Does this give the result you that desire.

[marcustofeles]

My DB is now almost completely stripped, yet it's 1,5MB.

[marcustofeles]

Dear Bob, you're a genius!!!

Works flawlessly! I'm so grateful for all your help!

[Bob Fitz]

I'm glad that we have been able to help.

BTW: Should you need to post a copy db in the future, first run Compact and Repair. Then "Zip" the bd file. The zipped file was only 231 KB when I tried it with your db.

[marcustofeles]

Gotcha. Thanks again man!!!