mirror contents of listbox in a textbox (1 Viewer)

[CoffeeGuru]

There are probably better ways of doing this but heres mine and it needs help...

I have a drop down box where I select a Retailer
When this choise is made I want the last invoice entry to appear in a text box.
I have attepted this by creating a query which contains the top 1 invoice in decending order
My dropdown box Event updates a hidden List box using List677.Requery
and List677 has a SELECT statement in Row Source
So far so good this bit works

Now come my challenge
I want to use this value as a default in a Textbox
I thought I could use the same trick to populate the Textbox as I did the Listbox so i tried Text232.Requery after the List677.Requery in the Event above.
but no it does not update
The only time the textbox updates is if the Listbox is in Focus and as I said this List box is Hidden.
How can I get the textbox to change in real time...
I would use the Listbox but i need to be able to change the value of the contents to run reports, I just want a default value.

textBox Default Value: =[List677]
textBox Control Source: =[List677]

List677 Row Source: SELECT LastInvoice.Invoice FROM LastInvoice;

 

[GinaWhipp]

If I understand you correctly...

Try putting a

Me.YourTextBox.Requery

in the After_Update event of the List Box.

Side note, please give your Controls some meaningful names. Down the road you'll be happy you did and so will the person that *may* follow behind you.