ACCESS FEED: [MS_AccessPros] Control on Form Has Derived Data, Data Doesn't Persist to Table Column

Selasa, 24 Mei 2011

[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

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity: