Form macro

[- Butch]

Continuing from last week, I am adding more buttons to my video library
Switchboard, which in turn takes me to various Report Previews. Two things I
would like help with.

First, I would like to structure a query using the
[Forms]![PopUpForm'sName].[People] formula that was given to me earlier. It
works fine when there is only one name in the People field. Sometimes,
however, the field has multiple names so I would like to be able to extract
one name from the many. How do I structure the form view formula to work
like the generic Like "*Bob*"?

Second, when my Tape Number form opens and asks for a number, a Zero is
present which must be deleted before the correct number can be entered. How
do I get the form to open with a blank field with a blinking cursor so all I
have to do is enter the number I want?

Thanks.

 

[tina]

comments inline.

Continuing from last week, I am adding more buttons to my video library
Switchboard, which in turn takes me to various Report Previews. Two things I
would like help with.

First, I would like to structure a query using the
[Forms]![PopUpForm'sName].[People] formula that was given to me earlier. It
works fine when there is only one name in the People field. Sometimes,
however, the field has multiple names so I would like to be able to extract
one name from the many. How do I structure the form view formula to work
like the generic Like "*Bob*"?

try

Like "*" & [Forms]![PopUpForm'sName].[People] & "*"

Second, when my Tape Number form opens and asks for a number, a Zero is
present which must be deleted before the correct number can be entered. How
do I get the form to open with a blank field with a blinking cursor so all I
have to do is enter the number I want?

check the DefaultValue property of the control where the zero is showing up,
and remove it if it's there. if that doesn't take care of it, check the
DefaultValue property of the field in the form's underlying table.

hth