Competent Performer
Windows XP 
Access 2007
So I have a textbox called "Preferences" that contain values. I want to create a new field called "GRA" that is populated by values from "Preferences" if certain criteria is met. I noticed I can make the control source for the new field "GRA" set to "Preferences" but then anytime "Preferences" contains a value, it is also in "GRA". I just wanted certain values to be populated in "GRA".
Access Developer
Windows XP Access 2003
Hi
I would use If/Then/Else in the On Current event of the form to set the value of Gra.
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
Competent Performer
Windows XP Access 2007
Ok. So I would write a statement that would select the values I want extracted and populated in the other field?
Access Developer
Windows XP Access 2003
That's right
If this helped, please click the star at the bottom left of this posting and add to my reputation
Bob Fitzpatrick
Competent Performer
Windows XP Access 2007
Would I need to create a new field in the table first? Or can I just create a new textbox or combo box on the form, and populate it all within the form?
Posting Permissions
Reply With Quote