K
kknowles via AccessMonster.com
I have a form which has a control box on it. I have a query as the
recordsource for this form, which has a number of different fields in it -
one of which is called "PMRS#". I want to be able to use my combo box to jump
to a specific PMRS#, however i keep getting the error message "there is no
field named "PMRS#" in the current record".
In my combo box, my row source is a query which contains two fields: "PMRS#",
and "Description" which is a title for the PMRS#.
In the event tab of my combo box I am using a macro (named "findrec_PMRS") as
an after update event.
The findrec_PMRS macro contains two actions: gotocontrol (where my control
name is [PMRS#]) and findrecord (which finds the value of what was selected
in the combo box).
when i get the error message "there is no field named "PMRS#" in the current
record" , i click OK, and get an "action failed" box:
macro name: findrec_PMRS
condition: true
action name: gotocontrol
arguments: [PMRS#]
I have been stuck on this error for quite a while now and would appreciate
any advice.
Thanks,
- Kris
recordsource for this form, which has a number of different fields in it -
one of which is called "PMRS#". I want to be able to use my combo box to jump
to a specific PMRS#, however i keep getting the error message "there is no
field named "PMRS#" in the current record".
In my combo box, my row source is a query which contains two fields: "PMRS#",
and "Description" which is a title for the PMRS#.
In the event tab of my combo box I am using a macro (named "findrec_PMRS") as
an after update event.
The findrec_PMRS macro contains two actions: gotocontrol (where my control
name is [PMRS#]) and findrecord (which finds the value of what was selected
in the combo box).
when i get the error message "there is no field named "PMRS#" in the current
record" , i click OK, and get an "action failed" box:
macro name: findrec_PMRS
condition: true
action name: gotocontrol
arguments: [PMRS#]
I have been stuck on this error for quite a while now and would appreciate
any advice.
Thanks,
- Kris