M
Mike
I have table that stores group members and their relative information (name,
supervisor, etc). I have created a query to find only the current members.
I also have a table to store meeting attendance. I am developing a form for
this table. I have 10 combo boxed to select a members name. The row source
for these combo boxes is the membername field from the aforementioned query.
Insted of manually selecting each members name in the combo boxes, I would
like to set a default value. For example I would like the default value for
Member1 to be the first person listed in the current member query. The
default for Member2 to be the second person listed in the query. This way
when a person leaves the group I do not have to manually change the default
values. I have not been able to setup the default values here. Is there a
way to set the default value based on a row of a query? Something like:
me.member1=Query!CurrentMember!membername(x)
where x is the row number? Is there a better way to do this?
Thanks,
supervisor, etc). I have created a query to find only the current members.
I also have a table to store meeting attendance. I am developing a form for
this table. I have 10 combo boxed to select a members name. The row source
for these combo boxes is the membername field from the aforementioned query.
Insted of manually selecting each members name in the combo boxes, I would
like to set a default value. For example I would like the default value for
Member1 to be the first person listed in the current member query. The
default for Member2 to be the second person listed in the query. This way
when a person leaves the group I do not have to manually change the default
values. I have not been able to setup the default values here. Is there a
way to set the default value based on a row of a query? Something like:
me.member1=Query!CurrentMember!membername(x)
where x is the row number? Is there a better way to do this?
Thanks,