selheight question

[Lenny Fincher]

I have a form with a subform. I want to allow multiple subform
records to be selected and processed. I am using selheight and seltop
to determine which records to process. No matter how many records I
select, selheight = 0. I have opened the form and gone to the
immediate window to test this out. If I select multiple records and
enter the command ?Forms!vendir!requests.Form.SelHeight it prints the
correct count. If I put a breakpoint on the first line of executable
code of the command button that performs the process and get into that
breakpoint and then key the same command in the immediate window, the
return answer is zero (0). As soon as the process starts, the count
goes to zero. The seltop property works correctly throughout.

The form is Vendir. The subform is Requests.

Any suggestions?

[Allen Browne]

Command button? You're using a command button?

Would not the multiple selection be lost when focus moves to the command
button?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Lenny Fincher" <pi******@charter.net> wrote in message
news:df**************************@posting.google.c om...

I have a form with a subform. I want to allow multiple subform
records to be selected and processed. I am using selheight and seltop
to determine which records to process. No matter how many records I
select, selheight = 0. I have opened the form and gone to the
immediate window to test this out. If I select multiple records and
enter the command ?Forms!vendir!requests.Form.SelHeight it prints the
correct count. If I put a breakpoint on the first line of executable
code of the command button that performs the process and get into that
breakpoint and then key the same command in the immediate window, the
return answer is zero (0). As soon as the process starts, the count
goes to zero. The seltop property works correctly throughout.

The form is Vendir. The subform is Requests.

Any suggestions?

[Lenny Fincher]

Yes, Allen. That does seem to be the problem. Thanks for the heads-up.

Lenny Fincher

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message news:<40**********************@per-qv1-newsreader-01.iinet.net.au>...

Command button? You're using a command button?

Would not the multiple selection be lost when focus moves to the command
button?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Lenny Fincher" <pi******@charter.net> wrote in message
news:df**************************@posting.google.c om...

I have a form with a subform. I want to allow multiple subform
records to be selected and processed. I am using selheight and seltop
to determine which records to process. No matter how many records I
select, selheight = 0. I have opened the form and gone to the
immediate window to test this out. If I select multiple records and
enter the command ?Forms!vendir!requests.Form.SelHeight it prints the
correct count. If I put a breakpoint on the first line of executable
code of the command button that performs the process and get into that
breakpoint and then key the same command in the immediate window, the
return answer is zero (0). As soon as the process starts, the count
goes to zero. The seltop property works correctly throughout.

The form is Vendir. The subform is Requests.

Any suggestions?

[Stephen Lebans]

Create module level variables for the form's SelTop and SelHeight props
that you update using the Form's Click event.
Finally the Access Web contains sample code based on a Timer event that
you can use by simply substituting the method outlined above.
http://www.mvps.org/access/forms/frm0033.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Lenny Fincher" <pi******@charter.net> wrote in message
news:df**************************@posting.google.c om...

I have a form with a subform. I want to allow multiple subform
records to be selected and processed. I am using selheight and seltop
to determine which records to process. No matter how many records I
select, selheight = 0. I have opened the form and gone to the
immediate window to test this out. If I select multiple records and
enter the command ?Forms!vendir!requests.Form.SelHeight it prints the
correct count. If I put a breakpoint on the first line of executable
code of the command button that performs the process and get into that
breakpoint and then key the same command in the immediate window, the
return answer is zero (0). As soon as the process starts, the count
goes to zero. The seltop property works correctly throughout.

The form is Vendir. The subform is Requests.

Any suggestions?