Refresh Unbound Form after adding data

[mousemat]

Hi all

I have been working on a Stock / Inventory Database which is fairly simple for my requirements.

I have an unbound form with a Combo Box populated via a query. The form displays the stock levels taken from the query / combo box. Also on the form are four fields that allow me to enter stock movements and a description of movements.

I have a button that adds the data to the table.

All this work well. Except that for the life of me, I can not get the form to update with the new totals etc. In order for the form to update, I have to close and reopen the form.

I have tried refresh, requery and recalc, I'm obviously doing something wrong, placing the commands in the wrong places etc.

I have added the db here. What am I missing? Any help would be gratefully received.

 

[JHB]

..
I have a button that adds the data to the table.

Not in the version you posted here - the only thing that get added to the table is the time and the transaction description.

 

[mousemat]

Hmmm thats odd.

Heres a working DB then which does add the data to the table.

 

[arnelgp]

You need only to requery the textbox concerned and not the form.

 

[mousemat]

The textbox is being populated by the combo box via a query

 

[JHB]

Try it now:

 

[arnelgp]

Here is the fix mr.mousetrap

 

[mousemat]

Try it now:

Excellent. Many thanks for that.

 

[mousemat]

Here is the fix mr.mousetrap

Many thanks for your answer too.

 

[JHB]

Excellent. Many thanks for that.

You're welcome.