Forgive me if I put up a rather simple question, but how to do the form as I want?
I have a table of information about Fields. They may be approved or not approved. The two exclude each other so it is a simple "yes/no". In human terms, the user knows that it's not approved until positively approved.
My field table thus looks like this:
I query this table in order to find relevant information. Also, I need to look at information from the field table in a query together with other information, but that is immaterial here. So for the simple version, the query I made will look like this:
This query I would now like to put into a form for user access. This is simply done and looks like this:
The example above is row no. 2, showing us information about field no. 3, and that it is approved. The user only need to look at one field at a time, so a simple form like this works well.
However, for the visual impact on the user, I would lke the user to be presented to a choice between "approved" and "not approved", rather than the yes/no checkmark. It looks better with radio buttons showing that user these two options, like this (the below image is edited in paint to look like what I want, representative of what I cannot actually do in Access):
Naturally, these radio buttons should exclude one another, so as soon as one is selected, the other is deselected, relative to the option of "approved" having a checkmark or not.
Alternatively, it would also be fine to have checkboxes there instead of radio button, as long as the functionality is the same (checking one unchecks the other, and corresponds to yes/no in the table). Like this:
The last option is actually the preferable one (because it looks like this in a paper form we receive from customers), but I'm not sure it can be done in access.
This should be simple, right? I just can't figure out how