I have a form based on a table whose sole function is to edit records in that table. One data item is Yes/No, but when I display it in the form it shows as 0 or 1. I want it to show as Yes or No, or as a little box with or without a tick. How?
Secondly, another form, this time creating new records. It has two linked combo boxes, the first filters records from a table so that only those relevant to its contents show as options in the second (using ReQuery). It works fine. But after creating the first record the contents of the first box remain displayed, and have to be deleted before you can overwrite them. I want them to clear. I've tried to set the default value for this combo box in form properties using OnLoad, but I get a #Name? error. Don't understand it.
Any suggestions?
Secondly, another form, this time creating new records. It has two linked combo boxes, the first filters records from a table so that only those relevant to its contents show as options in the second (using ReQuery). It works fine. But after creating the first record the contents of the first box remain displayed, and have to be deleted before you can overwrite them. I want them to clear. I've tried to set the default value for this combo box in form properties using OnLoad, but I get a #Name? error. Don't understand it.
Any suggestions?