FORMS

[B Bach via AccessMonster.com]

Hello,

I have one table: SURVEY_tbl
with a primary key: FORMID

I split the SURVEY_tbl into eight separate forms for data entry. I used
macros to open the forms . The problem I am having is when I began to put
data entry into the first two forms it is fine, but on the third form I get a
duplicate error. I look in the SURVEY_tbl and sure enough the 1st form has a
row all its own. The fields in the 3rd -8th forms are on a separate row with
no primary key. How do I get the forms to synch?


thanks..

 

[tina]

is there a particular reason that you *must* use multiple forms to enter a
single record in the table? if you're simply wanting to group the tables
fields into distinct groups that are presented to the user "separately",
then have you considered binding your table to one form, putting a tab
control on the form, and then putting controls on separate tabs to group the
table's fields as desired?

hth