editing a record from an order form

[campbellbrian2001@yahoo.com]

I'm looking at the Access2003 Northwind Database Orders form uopn which
I'm basing a similar form for my company's use. How can I take a
particular record in the subform and open an actual edit FORM I would
design? This would allow the users to change specific things about the
product record in a form fashion.
Thanks All!
Brian

[Benny Andersen]

Re: editing a record from an order form

On 14 Apr 2005 07:19:21 -0700, campbellbrian20 01@yahoo.com wrote:
[color=blue]
>I'm looking at the Access2003 Northwind Database Orders form uopn which
>I'm basing a similar form for my company's use. How can I take a
>particular record in the subform and open an actual edit FORM I would
>design? This would allow the users to change specific things about the
>product record in a form fashion.
>Thanks All!
>Brian[/color]
You can open the edit form using a filter (wherecondition ) from a
popup menu of the fields of the subform.
Let us asume the subform has a unique field named 'id'. The popup can
then call the edit for using
docmd.openform "editform",,,"i d=" & id
--
Benny Andersen