Cant edit record on a form

  • Thread starter Thread starter pierre
  • Start date Start date
P

pierre

Hi all,

i have a form use to edit two table that are linked by a field.

So the form recordsource is a query

Recently i modify the link between the two table
Now the link is made by two fields.

The record display correctly but now it is impossible to edit
the data on the form.

Looks like each record is locked.

Is there a way to edit with a multiple field link or is it impossible

Regards,

Pierre
 
Hi all,

i have a form use to edit two table that are linked by a field.
Click to expand...

The simplest way to do this is to use a Form for the "one" side table
and a Subform for the "many", rather than basing the form on a query
joining the two tables - have you tried this?
So the form recordsource is a query

Recently i modify the link between the two table
Now the link is made by two fields.

The record display correctly but now it is impossible to edit
the data on the form.

Looks like each record is locked.

Is there a way to edit with a multiple field link or is it impossible
Click to expand...

You must have a two-field unique Index (such as a Primary Key) on the
linking fields. Open the "one" side table in design view; ctrl-click
the two fields which you want to use for linking so that they are both
selected; and click the "key" icon. You should see a key indicator
beside both fields.

John W. Vinson[MVP]
 
Back
Top