Access Contact Data base reverses Landlines and Cell numbers

Chris and Marja Blase 0 Reputation points
2023-01-22T23:43:14.01+00:00

I am assembling a contact database in Access. When I click the Directory button, it puts the land line number in the cell phone spot and visa versa. It does not do that in the Telephone list feature. I use Windows 365 and it is up to date.

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
797 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Maria Barnes 11 Reputation points MVP
    2023-02-02T14:30:23.3666667+00:00

    @Chris and Marja Blase check the macro or code behind the Directory button. You should be able to see these fields getting set or the query that is being run and modify.

    0 comments No comments

  2. Ken Sheridan 2,581 Reputation points
    2023-02-03T12:46:28.9033333+00:00

    What are the ControlSource properties of the land line and cell phone controls in the directory? It sounds like they are transposed.

    0 comments No comments

  3. Ken Sheridan 2,581 Reputation points
    2023-02-03T12:49:10.2666667+00:00

    What are the ControlSource properties of the land line and cell phone controls in the directory?

    0 comments No comments