I have a append query where I have some fields that the operator needs to enter either Yes/No, which at the moment, the operators are keying 1 or 0.
I also have a field that I need to have inputted correctly and therefore on the form, this relates to a combo box. However, I want to bring this to the query, so when the query is run and you are prompted for data - you choose from the combo box.
This is for an append query - I have one field that when running the report, I want the user, when prompted to add data, to only be able to choose from the pre-set options.
The example is that the append query will update many records with the same information. I currently have the append query set for the user to add data for Date >, Date < and closure reason. What is happening is that we have set data for closure reason, however, due to operator keying, some enter different data, ie., close, closed, closing, to be closed etc.
For reporting reasons, I want to streamline the data that they can add to the set data format, ie., in progress, closed, with specialist.