Your form requests a prompt when opened. Also, there are no data, so it's hard to see what you want to accomplish.
HI theDBguy ....nice to contact you again....
to make things clearer I should write my steps to show data and what i want to achieve.....
1. choose zone from drop down list...
2. choose driver name
3. then click done button to
change and
fill the records (status and driver name) that have "true" value for its check box ....
change default value of status from "AB" TO "CD"......( "AB' is the filter value of the form and the default value of the field)...
fill driver name for all chosen records with the chosen driver name in the drop down list .....
check attached modified test db....
hope my English is clear because I am Arabic speaker and my data is in Arabic and this "test db" just to make it clear for you....
thanks in advance
BTE ..CmdSelect_Click vb code is yours ^_^.... from previous help
.............
+++++
IT SEEMS this one is ok
hi all NICE to contact you again I need help how to make "DONE button" in my continuous form work for all fields not the first active field only !!! thanks in advance
www.access-programmers.co.uk