Terry-O
Set the Control Source of the Date 1 text box to the Date 1 field in the table.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of terryomsn
Sent: Wednesday, May 25, 2011 2:56 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Control on Form Has Derived Data, Data Doesn't Persist
to Table Column
Hi,
In Access 2003,
I have a form that is based on one table called tblImportedData.
In the form, I have one bound text box [RawData] that I use to paste a file name
into.
During data entry, I parse the [RawData] text box into another form unbound text
control called [Date 1] using =Left(Right([RawData],27),8) after the RawData
text box control is populated.
The Date 1 text box correctly shows the 20110430 number that I'm looking for.
I also need the values in the Date 1 text box control to be updated into a [Date
1] column in tblImportedData.
How can I persist the 20110430 value from the form's Date 1 text control into
tblImportedData Date 1 column?
Thanks for any help you can offer.
Terryomsn
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar