Share via

you entered an expression that has an invalid reference to the property page

Anonymous
2013-07-31T15:58:00+00:00

I created a form with a button option group to filter and display sets of personnel records by organization.  When I try to re-sort the form/data by another field - I get a message box saying...["you entered an expression that has an invalid reference to the property page. The Property may not exist or may not apply to the object you specified."]  Then form sorts the data OK as selected.  Just wondering why it throws this error message and then works/sorts OK.  I copied the form from another form with a button option group that select (filters) names by first letter of last name.  The original form will re-sort OK without the error message.  Is there any adjustment possible in the copied form that would help remove the error message.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

15 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-10-04T00:13:05+00:00

    I know this thread is over 3 years old but I had the same issue and it's caused by conditional Formatting of a field in a continuous form. Using Has Focus on a field in the Conditional Format and the using the right-click filters results in this annoying Error. If you right click and set the custom filters it will not throw this error. Annoying to say the least!

    Actually ANY field that has Conditional Formatting on it will throw this error IF you right-click and filter on it.

    Hope this helps someone out there.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2013-08-01T16:17:18+00:00

    Gina - it is the Customer PHONE LIST form in the Northwind DB.  The button option group is at the bottom.  I was thinking of re-creating my Org Copy from scratch - since I am not sure what to adjust.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2013-07-31T19:35:30+00:00

    I am in the 2010 Northwind database and I see no Option Group on any Customer forms.  What am I missing?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2013-07-31T19:16:34+00:00

    Gina - When I copied the form I added and removed a few fields.  Two fields are the same (Ful_Nme and Pos_Num).  There is NO VBA code behind the form - so I am not sure about what to 'adjust to Reference the Form/Field name changes'.  The button Option group is modeled after the button option group in the 'Customer Phone List' in the Northwind DB.  When I copied the 1st form (phone list) to the 2nd form I just changed the where condition in the AFTER_UPDATE macro...e.g., ..FROM [FUL_NME] Like "B*" ... to ....  [ORG_ACR] Like "*AM*" and changed the button captions.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2013-07-31T18:01:00+00:00

    Sounds like when you copied it you didn't adjust the code to Reference the Form/Field name changes.  Look into that and it should solve your problem.

    Was this answer helpful?

    0 comments