What you're seeing usually occurs when the underlying table or query
contains no records and the table/query isn't updatable. I'm assuming the
form is based on a query; you can find it in the form's Record Source
property. Try making a copy of the Record Source code and pasting it into a
blank SQL window (create a new query in Query Design mode, close the table
selection window, then switch the view to SQL). See if you can run the code
in the SQL window, and once it runs see if you can update records or add new
records. If you can't add/update records, your query is non-updatable. You
may need to rethink your query design to make it updatable.

Suggestions: I'm guessing that if your query is based on all three tables
it's probably non-updatable. If members can only belong to a single group,
there's no reason to store the member group in a separate table so you could
eliminate one table right there. If members can have multiple addresses, it
would be better to set up your form in a parent-subform arrangement, where
the parent form is based on tblMember and the subform is based on
tblMemberAddress. That way, the main form is based on a single table and you
won't usually see non-updatable records; records added to the subform will
automatically pick up the member id.

Carl Rapson

Use a Form bound to the members table, and Subforms bound to the other two
tables.

            John W. Vinson [MVP]