On Mar 26, 5:35*pm, Patrick A <park...@stradley.comwrote:
Quote:
Sorry about the auto-post. *Don't know what keys I hit.
>
I have a continuous form with a combo box and a field on it, and a
combo box in the footer.
-----------
{body cbox} * [field]
-----------
{body cbox} * [field]
-----------
______
-----------
[footer cbox]
-----------
>
Let's say the combo box on the form is for the drinks I want...and I
can choose Martini, Gimlet, etc.
>
I can choose as many drinks as I want.
>
The combo box in the footer is my choice of liquor.
>
-----------
Gimlet * [liquor]
-----------
Martini * [liquor]
-----------
______
-----------
Gin
-----------
>
I only get to choose one type of liquor for any and all drinks. *(Sad
example, but there you go. *This is driving me to drink.)
>
Right now, the way my form behaves is when I change my type of liquor
in the footer, it only changes the type of liquor for the row I am
"on" in the body of the form. *(I'm using an after update event in the
combo box in the footer:
Me.TB_Body = Me.CB_Footer.)
>
How can I get it to change the type of liquor for ALL rows in the body
of the form?
>
Thanks,
>
Patrick
Patrick
Just be careful not to drive after drinking.
You can use a loop to go through all the rows in the form. I haven't
done this so i don't know the exact commands (those inside #) for most
of this so here is my best.
for i = 1 to #recordcount#
Me.TB_Body = Me.CB_Footer.
DoCmd.GoToRecord acDataForm, "FormName", acGoTo, i
next i
I can't find how to get the number of record in the Form. Best why i
can think of is to have a text control that counts the total number of
fields Count(*). And using that. Perhaps somebody else has a better
solution. Most of the stuff i've found in the net, have a ton of
coding.
- GL
