Prev: Error 94 Invalid use of Null
Next: Referencing subform from another form
From: ThomasAJ on 29 Dec 2009 21:00
I want to open FormP from FormA.

I want to restrict FormP to ONLY show 1 Product - so how do I 'feed' the
product number from FormA so FormP shows only that product and has bound
controls to the Product Table so that changes made in FormP update the
Product Table.

--
Regards
Tom
From: Arvin Meyer [MVP] on 29 Dec 2009 23:49
In the Click event of the button on FormA, a bit of code like:

DoCmd.OpenForm "FormP",,, "ProductID =" & Me.txtProductID

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"ThomasAJ" <ThomasAJ(a)discussions.microsoft.com> wrote in message
news:E6B4EAA4-9BC9-48F9-8931-99A28E8D28D6(a)microsoft.com...
>I want to open FormP from FormA.
>
> I want to restrict FormP to ONLY show 1 Product - so how do I 'feed' the
> product number from FormA so FormP shows only that product and has bound
> controls to the Product Table so that changes made in FormP update the
> Product Table.
>
> --
> Regards
> Tom


 | 
Pages: 1
Prev: Error 94 Invalid use of Null
Next: Referencing subform from another form