using screen...

[SF]

Hi,

I have problem with the query in the cascade combobox when the form name
change.

Is there a way to replace the following using screen.activeform

[Forms]![frmCoFundReview]![Partner] => screen.activeform.[Partner] ?

SF

 

[Jeanette Cunningham]

Not that I know.
You could use a separate query for each form.
Each query would have the correct form name for the combo box.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Tom van Stiphout]

On Tue, 23 Mar 2010 13:29:38 +1100, "Jeanette Cunningham"

Sure. It will require a bit of VBA.
Replace this: [Forms]![frmCoFundReview]![Partner]
With this: GetPartner()
Then write this in a Standard Module:
(Note: I'm guessing Partner is a string)
public function GetPartner() as string
GetPartner=screen.activeform("Partner")
end function

-Tom.
Microsoft Access MVP

Not that I know.
You could use a separate query for each form.
Each query would have the correct form name for the combo box.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Hi,

I have problem with the query in the cascade combobox when the form name
change.

Is there a way to replace the following using screen.activeform

[Forms]![frmCoFundReview]![Partner] => screen.activeform.[Partner] ?

SF