jenny_gurl
jenny_gurl
- Local time
- Today, 23:02
- Joined
- Oct 10, 2005
- Messages
- 23
hi,
I have a form which is based on a query that displays the expenses for a given month(the parameter value).
In my expense table i had set up the month field as a lookup column which basically consisted of two columns, one was the month and the other the numerical value of that month. for eg. if the month is August, then the numerical value is 8. i had set this lookup column in such a way that if the user were to directly edit the table (which i don't want) he would have to click the drop down box and he would see only the name of the months, not the numerical value. (i set the numerical value column to width 0")
if the user makes a selection (in the table) that field takes the numerical equivalent of the month which is fine.
The trouble is that things screw up when i use the form. This form is actually a subform. In my main form i have an option group (with toggle buttons to represent the 12 months). Everytime the user clicks any of the toggle buttons in the option group the subform is requeried, and the chosen month's records are displayed.
The trouble is when i do this, the month is displayed not as aug, sept etc but as its numerical equivalent. (However since the month field is shown with a drop down arrow, the user can still make a selection, and when he/she does so, the month for that field is shown as the name!)
I need the form to display the records as the name of the month and not the number. the number was only so that the form qould be requeried using the option group. Can someone help me out here!!!!
Hassled,
I have a form which is based on a query that displays the expenses for a given month(the parameter value).
In my expense table i had set up the month field as a lookup column which basically consisted of two columns, one was the month and the other the numerical value of that month. for eg. if the month is August, then the numerical value is 8. i had set this lookup column in such a way that if the user were to directly edit the table (which i don't want) he would have to click the drop down box and he would see only the name of the months, not the numerical value. (i set the numerical value column to width 0")
if the user makes a selection (in the table) that field takes the numerical equivalent of the month which is fine.
The trouble is that things screw up when i use the form. This form is actually a subform. In my main form i have an option group (with toggle buttons to represent the 12 months). Everytime the user clicks any of the toggle buttons in the option group the subform is requeried, and the chosen month's records are displayed.
The trouble is when i do this, the month is displayed not as aug, sept etc but as its numerical equivalent. (However since the month field is shown with a drop down arrow, the user can still make a selection, and when he/she does so, the month for that field is shown as the name!)
I need the form to display the records as the name of the month and not the number. the number was only so that the form qould be requeried using the option group. Can someone help me out here!!!!
Hassled,
