Murray Brown
asked on
Access - Hide identity values in a form
Hi
I want to find a way to hide Access Identity values in a form without the use of subdata sheets.
In the form shown below there is a column called Status ID that holds a integer value that
relates to another column called Status. These two columns are in the "Order Details Status"
table.
I would like the user to rather see one column with the words (eg "Allocated", "On Order" etc)
and make there selection in any row of that column. Is there a way to achieve this without the use of subdata sheets?
For example can you use a query as the source of the form?
Thanks
I want to find a way to hide Access Identity values in a form without the use of subdata sheets.
In the form shown below there is a column called Status ID that holds a integer value that
relates to another column called Status. These two columns are in the "Order Details Status"
table.
I would like the user to rather see one column with the words (eg "Allocated", "On Order" etc)
and make there selection in any row of that column. Is there a way to achieve this without the use of subdata sheets?
For example can you use a query as the source of the form?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER