Hi,

It's like what the subject says...

I am selecting some options in some combo boxes that have their control source in tblDates.

At the moment I am having to select my options then exit the form and then go back in in order to get the new selections updated in my table...

There HAS to be an easier way...

Update Querys just seem to want to update a record in one table with soem data from another...

I can't get one to pick up the contents of a combo and force the data into the right table immediately...

Hopefully someone has an idea...

why use a query at all and not just bind the table to the form directly?

Regards

It is...

but until I close the form down the table is not updated, it doesn't seem to work real-time!

Closing the form makes an implicit save then. Try using a "default save" button from the wizard. Should do the trick.

Regards

Oh so simple!!! :D

Thanks AGAIN namliam!!

The mailman delivers again!!

:D