Forms, subforms, and adding new records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Okay, so I built a form with five subforms (because I couldn't get the form
to accept merging fields into one form - the relationships got confused).

So, it all seems to work; except, after inputing the data, when I try to add
a new record (with the arrows at the bottom of the main form) Access won't
let me add a new record. The [*>] button is gray, and the only ones active
are the [<<] and [>>] buttons. But when I click those, of course, it just
recycles the same data already on my screen.

My Primary Key is an automatically generated number; "Member #" , which I
have related to the same field in all the other tables (as a Foreign key with
the same properties as the Primary key - long integer).

I have supressed the navigation buttons and record selectors from the
properties box on each of the subforms (so as to avoid data entry confusion).
But I left those properties defaulted on the main form. Did I cause bigger
problems formyself by doing this?

I'm sure that I'm missing something ... but after many, many hours, over
several days, of trying to troubleshoot it myself, and reading a stack of
books, I can't figure it out. I am in great need of your expert advice!

Any help you might offer would be tremendously appreicated! I would like to
move to Phase II of my project, and this is holding me back.

Thank you very much!!!
 
simplest first: In the main form, in the data tab, have you got the
allow add set to yes?

Then more complicated: What is the source data for the main form? if
it is a complex query, it may not let you add. If it involves sums etc,
then you will NOT be able to add.

The group needs more information.
 
Back
Top