jebushatescats
IS-IT--Management
Hello all
I have form with a series of controls tied to a recordset
The first control is combo box that the user can select a name from. The form also has a check box tied to a field in the same record.
When the user selects a name I execute a requery, Me.Requery, my problem is that the user may select a name by typing in the first several characters of the name, once the correct name appears they are then clicking on the check box to select it. This causes the requery to take place and the application 'forgets' that the check box has been selected. Is there a way of remembering that the check box has been selected so that I can set it to checked after the requery has taken place?
I have form with a series of controls tied to a recordset
The first control is combo box that the user can select a name from. The form also has a check box tied to a field in the same record.
When the user selects a name I execute a requery, Me.Requery, my problem is that the user may select a name by typing in the first several characters of the name, once the correct name appears they are then clicking on the check box to select it. This causes the requery to take place and the application 'forgets' that the check box has been selected. Is there a way of remembering that the check box has been selected so that I can set it to checked after the requery has taken place?
