Hi All,

I need to bind fields using an expression in a form to a table.

http://www.access-programmers.co.uk/ubb/smile.gif My situation is as follows:

In one of my forms I have to enter the [Invoice Date]. Two other fields derive the [Budget Year] and [Quarter] from the Invoice Date by use of a expression placed in the Control Source box. For instance, =Switch(Format([Budget Date];"q")="1";"4";Format([Budget Date];"q")="2";"1";Format([Budget Date];"q")="3";"2";Format([Budget Date];"q")="4";"3")

Unfortunately the data entered in the fields isn't copied to my Budget Table (to which the form is linked). However, I did add a column [Budget Year] as well as [Quarter] to the [Budget] table. How can I make sure the entered data is copied to the Budget Table?

Regards,

Therese

Please don't repeat the same post under different topics. It will fragment your help and only annoy the people who take the time to read and answer a question when there was already a perfectly good answer posted already under another topic.