hardhitter06
Registered User.
- Local time
- Today, 11:31
- Joined
- Dec 21, 2006
- Messages
- 600
Hello All,
Access 2003.
Edit: These fields are on my input form.
I have a field called "GeneratedItemNumber" in my table "tblMain". This field uses a number field "MyNumber" and a category field "Category" and combines these values using this code in the generateditemnumber control source:
=DLookUp("CategoryAbbr","tblcategory","category='"+[category]+"'") & [mynumber]
Works great except this value isn't store in my "tblMain" for obvious reasons because the control source isn't "generateditemnumber". I was wondering what steps I need to complete in order for this value to be stored in my table??
In other words, I will need to query by this item number down the road and if it isn't being stored (in tblMain in particular), I won't be able to locate these records by their item numbers...
Thank you in advance,
Josh
Access 2003.
Edit: These fields are on my input form.
I have a field called "GeneratedItemNumber" in my table "tblMain". This field uses a number field "MyNumber" and a category field "Category" and combines these values using this code in the generateditemnumber control source:
=DLookUp("CategoryAbbr","tblcategory","category='"+[category]+"'") & [mynumber]
Works great except this value isn't store in my "tblMain" for obvious reasons because the control source isn't "generateditemnumber". I was wondering what steps I need to complete in order for this value to be stored in my table??
In other words, I will need to query by this item number down the road and if it isn't being stored (in tblMain in particular), I won't be able to locate these records by their item numbers...
Thank you in advance,
Josh