union query help

[davewex]

I need to write a query that will take a date from txt box A, an amount
from txt box B, and place the combined value into combo box C.

Each time the A and B are modified I need these new values to go into
C. Please help

 

[fofa]

If you are trying to update a form, then you need to use VBA to do this.
There is a VBA function to add items to a Combobox. Check VBA help. I
think it is itemadd, but it's been awhile since I have needed to use
it.

 

[David]

HI,

I think you could also do it if the form were based on a query. One of the
columns in your query would calculate your string. Then refresh your screen
when you leave box B. Should work.

another Dave