Another alternative to George's suggestion is to put your Expression in the Default Value of the textbox. That way when you create a new record, the value gets saved into the field / Table.
Dawn Crosier "Education Lasts a Lifetime" This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn as well. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of hvadney Sent: Wednesday, October 25, 2006 6:58 AM To: [email protected] Subject: [ms_access] Expression Results to Table Hi, everyone: I was wondering why I had received NO responses to my question and I now see why: my messages are not appearing on the list. Any clues why that may be? Anyway, I am still having trouble getting my Expression field results to enter in my table from the form, where the results appear fine. Here's my original question again. Thanks for any help you can provide! ********* Hello, everyone: Small problem in my DATEADD expression in Access. I have set up the expression: =DateAdd("d",+21,[DateServed]) Where DateServed is the date to which 21 days is to be added to obtain the value for DateDue. When typing the dates into the form the expression works perfecty. I have another expression DateDiff: =DateDiff("d",[DateDue],[DateReceived]) which works in the form and returns the difference between the date due (DateDue) and the date received (DateReceived). It works fine in the form. My problem is that it does not appear in the table in the respective DateDue and DateReceived columns. Note: In Properties Data--Control source, the expression appears. When I click the down arrow to select the field into which the data is to be stored it shows the expression. If I select the field, the field appears in the expression builder window. In other words, if in Properties--Data--Control Source -- I select in Control Source (down arrow) the field into which the data is to be inserted, I lose the expression (the fieldname then appears in the expression builder as well); if I don't select the field but insert the expression into the box or use the expression builder, I lose the field name into which the data is to be inserted and the data is not inserted into the table but it works in the FORM! Any ideas why the data is not getting to the Table? Thanks, Harold Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ms_access/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
