Steve Schabel clarification please

[Omar]

Steve, thanks for the help..but I can not get it to work
properly. When I select the activity from the activity
combo box, I get an error. something like "Microsoft can
not move focus to basketball" tab..

Omar,

Within the same macro that you use to go to the required
subform/tab,
you can also put a series of SetValue actions, one for
each of the
other tabs. In the Item argument, put the equivalent of...
[NameOfTab].[Enabled]
..... and in the Expression argument, put No.

- Steve Schapel, Microsoft Access MVP

 

[Steve Schapel]

Omar,

Can you please give full details of the macro you are using.

Also, please respond to this post, so we keep the transactions in the
same thread, rather than starting a new thread in the newsgroup.

- Steve Schapel, Microsoft Access MVP

 

[Omar]

Steve, thanks again for the reply. I got it to work, but
now i stumbled on something else.Im trying to do one of
the following:

create a macro that would change the entry in the activity
type field located in the main form depending on tab
clicked..if you remember you (and Tina) helped me do the
opposite.. using the gotocontrol command..(the opposite:
make selection from combo box and point to specify
subform)..

I wrote a macro that looks like this..

Condition Action
[TabCtl24]=0 SetValue

Item -- [Forms]![Activities_Entry]![Activity_Type]
Expression -- [Basketball]

I believe I have to use full syntax to locate focus for
Item, this is because the Activity_type combo box is
located on main form not subform.. but even so, this
should not create that error. The main form name is
Activities_Entry, the combobox is called activity_Type.

I get this error:
"The value you entered is not valid for this field,
example..The number is larger than fieldsize setting
permits" error. any suggestions?

but offcourse the field entry is not creater than the
fieldsize nor is it a different datatype.
OMAR

-----Original Message-----
Omar,

Can you please give full details of the macro you are using.

Also, please respond to this post, so we keep the transactions in the
same thread, rather than starting a new thread in the newsgroup.

- Steve Schapel, Microsoft Access MVP

 

[Steve Schapel]

Omar,

The way to refer to a main form from a macro activated from a subform
event is to use the Parent operator. Therefore, the Item argument in
your macro should be...
[Parent]![Activity_Type]

However, I think the error you are getting relates to the Condition.
I am not clear what you are really trying to do. I don't understand
the meaning of [TabCtl24]=0 and obviously Access doesn't know what you
mean either. A tab control does not have a value.

- Steve Schapel, Microsoft Access MVP