如何使用ageband选择一个类别并插入表格中的字段？ [英] How to use an ageband to select a category and insert into a field in a table?
问题描述
我在桌子上有很多年龄段的自行车运动员，每个年龄组都有一个类别。
表格中的字段是agefrom。 ; " ageto" ; "类别" "的categoryID英寸; 性别
这是一个可以随时更新新类别或更改的表格。
即表格中
" agefrom" = 19
" ageto" = 29
然后category = elite
或
" agefrom" = 17
" ageto" = 18
然后类别=初级男性或女性
等等
我需要添加骑车人的年龄类别为骑车者的形式取决于他的年龄使用上表信息。 （已经计算了年龄。）
cyclistdetail表格中有姓名，地址，性别出生日期等字段。）
请帮助
Neels
I have plenty of age groups of cyclist in a table with a category linked to each age grouping.
The fields in the table are "agefrom" ; "ageto" ; "category" "categoryID"; "gender"
It''s a table that can be updated anytime with new categories or changes.
Ie in the table
"agefrom" =19
"ageto" = 29
then category = elite
or
"agefrom" = 17
"ageto" = 18
then category = junior male or female
etc etc etc
I need to add the cyclist''s age category to the cyclistdetail form depending, on his age using the above table info. (The age has already been calculated.)
the cyclistdetail form have fields like name, surname, address, gender date of birth etc.)
pls help
Neels
推荐答案
只需添加一个带有DLOOKUP（）函数的未绑定字段，如：
Just add an unbound field with a DLOOKUP() function like:
Thx Nico用于快速回复;将在明天尝试
Thx Nico for prompt reply; will try it tomorrow
似乎有问题
得到此错误#Name？
如果我在控制源中使用它txtbox = DLookUp（" categories"，" Category"，me.Age =" agefrom and ageto"）
field = categories
table = category
age是cyclistF表格中的字段，其中cyclistdetail出现
agefrom和ageto是类别表中的字段
i需要在cyclistF表单上提供年龄为我提供来自categorytbl的年龄类别
（我得到= DLookUp（[categories]，category，[agefrom] = Form！[age]）工作，但是，如果年龄值与年龄相符，则只给出categorytbl中的类别。
请帮助
thx
There seems to be a problem
get this error #Name?
if i use this in controlsource of txtbox =DLookUp("categories","Category",me.Age=" between agefrom and ageto")
field = categories
table = category
age is field on cyclistF form where cyclistdetail appear
agefrom and ageto are fields in category table
i need to have the age on the cyclistF form provide me with the age category from the categorytbl
(i get =DLookUp("[categories]","category","[agefrom] =Form![age]") working, but only gives the the category from categorytbl if agefrom value corresponds with age on form)
pls help
thx
这篇关于如何使用ageband选择一个类别并插入表格中的字段？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
