Search results

Ok... I am sure there's a better method but this worked: Added "RankType" to my original table field user|type ||RankType user1|TypeA || 1 user1|TypeA || 2 user1|TypeA || 3 user2|TypeB || 1 user2|TypeB || 2 user2|TypeB || 3 user3| TypeC || 1 user3| TypeC || 2 user3| TypeC...

Still stuck :( I did find putting this in the default filed =[Type].[ItemData](0) This will "default" (0) - 1st in list (1) - 2nd item in list (2) - 3rd item in list What I need is a variable to replace the =[Type].[ItemData](var1) so I can...

List from Query w/ Set List Item 'Default' from Query SO I have a form with a list box labeled type... Type: __________v Drop down will be from a query on a table returning TypeA TypeB TypeC I also need a default value in 'Type' from a query on a table where getuser() is used as a where...