different forms linked to one table

  • Thread starter Thread starter New TO Access
  • Start date Start date
N

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
 
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
 
Back
Top