RE:[visualbasic-l] Automatic Filling of One Field from Another Field in Same Record of Access Table

Reply from Rob Crombie on May 21 at 10:51 AM The tone was not needed, particularly when members are trying to help clarify the problem. This was a VB6 forum (primarily), and many VB6 and .NET programmers use Access, just as a database (the way god intended). I believe my question was valid. ---------------Original Message--------------- From: Dharm_Singh Sent: Friday, May 18, 2012 12:51 PM Subject: Automatic Filling of One Field from Another Field in Same Record of Access Table In an Access 2003 table, when a date field "C Ack" is filled up in a record, say "16-05-2012", I want that another field "ProdYear" of this same record may automatically be filled with "2012-13". In case the date field is filled with "20-02-2012", the another field of that record "ProdYear" should automatically be filled with "2011-12". For the date field "C Ack" of the table, I have made a Simple Query for the above purpose with following code :- ProdYear: IIF(DatePart("m",[C Ack])<4,DatePart("yyyy",[C Ack])-1 & "-" & Right(Year([C Ack]),2),DatePart("yyyy",[C Ack]) & "-" & Right(Year([C Ack])+1,2)) I want to eliminate the query and direct filling of ProdYear in the table is desired. Thanks! D.S.Pundir   Reply to this email to post your response.   __.____._ Manage Settings | Unsubscribe | Create FAQ | Send Feedback    Copyright © 2012 Toolbox.com and message author. Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251

Rob Crombie   7 achievements   Mark as helpful View this online Ask a new question   In the Spotlight Have a VB Question? Ask Your Peers at Toolbox for IT _.____.__