Creating a form with main form and subform based on the same table

[Guest]

Hi
Im working on a small database for my office. The problem i have is a form
where you can enter data in textboxes which represents the records in a
table, and below the textboxes i want a list(sheet-like) where all the
recorded data in the same table are showing. I want to be able to edit the
data in that list.

After trying for some hours i still havent figured out how to do this. Using
a main form with a sub-form has so far not worked. The thing that happens is
that only the record shown by the textboxes(main form) shown in the list(sub
form).

anyone have any tips on how to do this?

 

[John Vinson]

On Tue, 3 Jan 2006 13:28:02 -0800, "Exar Kun" <Exar

Hi
Im working on a small database for my office. The problem i have is a form
where you can enter data in textboxes which represents the records in a
table, and below the textboxes i want a list(sheet-like) where all the
recorded data in the same table are showing. I want to be able to edit the
data in that list.

After trying for some hours i still havent figured out how to do this. Using
a main form with a sub-form has so far not worked. The thing that happens is
that only the record shown by the textboxes(main form) shown in the list(sub
form).

anyone have any tips on how to do this?

Remove the Master and Child Link Field properties in form design -
just leave them blank.

Do note that you CANNOT have the same record open for editing on both
the mainform and the subform - Access cannot tell which edits should
be applied. This seems a rather odd thing to do, since you can edit
the data directly on a single form, *or* on a continuous form; I don't
see what benefit you get from trying to edit it both ways at once!

John W. Vinson[MVP]