different forms linked to one table

[New TO Access]

I am using Access 2007

I have a table that includes a memo control which will be populated with a
large list of data.

I want to open a new form, which shows the memo control, using a button from
the main form. I do not want to use a subform as it is too large.

I want the new form to update the data in the same recordset as the previous
form.

I have set the recordsource of the second form to the same table but I do
not know how to link it to the correct record so that any changes in the
memo field apply to the correct record.

Would appreciate any advice, thanks

David

 

[Tom van Stiphout]

On Thu, 18 Sep 2008 21:29:01 -0700, New TO Access

Study the line with "DoCmd.OpenForm" where you open the second form.
There is an argument called WhereClause which you can set to something
like:
"CustomerID = " & Me.CustomerID
That will make the second form open to just the current record.

-Tom.
Microsoft Access MVP