-- In AccessDevelopers@yahoogroups.com, "Jones, Glenn P MSG (Ret) FL- ARNG" <[EMAIL PROTECTED]> wrote: > > Do you have the words "premium", "full", and "newsletter" in this field or > is it like the Status field where you use a number to represent the active > or non-active status? > > Glenn P. Jones >
Thanks Glen, That is how i fixed my problem. MemberType is text, but in the one sample row, I have the number 1 in that field. If 1 = Yearly Member, then change MemberType to Number, Long Integer. On the Lookup tab, I had to make these settings: Display Control: Combo Box Row Source Type: Table/Query Row Source: MemberTypes Bound Column: 1 Column Count: 2 Column Heads: No Column Widths: 0";1" change the Record Source of my report to: SELECT Addresses.*, MemberTypes.MemberType AS MemberTypeDesc FROM MemberTypes INNER JOIN Addresses ON MemberTypes.MemberTypeID = Addresses.MemberType WHERE (((Addresses.Status)="Active")); And finally, change the Control Source of the Type text box to MemberTypeDesc. ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
