Loop on continuous form (1 Viewer)

[AsMok]

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

 

[theDBguy]

Your form requests a prompt when opened. Also, there are no data, so it's hard to see what you want to accomplish.

 

[arnelgp]

check and apply the code.
note this is not an "arabic" version.

 

[AsMok]

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

Loop on continuous form

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

 

[AsMok]

check and apply the code.
note this is not an "arabic" version.

Many thanks
I will try your code now and see the result....
BTW..my office and data is Arabic....
should I change the version?????

 

[arnelgp]

should I change the version?????

no, you just copy and understand the code on the button and code of the checkbox, etc.

 

[AsMok]

check and apply the code.
note this is not an "arabic" version.

IT seems up to now things is ok .......

I just changed >>>> (!ItemStatus = IIf(!check, "AB", "CD")) to this>>> (!ItemStatus = IIf(!check, "CD", "AB"))..

to get the exact change I want... I reviewed the changes in my table and it is exactly what I want....

I will work on it more to see if things is ok with my original data...

many thanks again and best wishes

 

[theDBguy]

Hi. Glad to hear you got it sorted out. Good luck with your project.