Wizard unable to open form in Form or Datasheet view

  • Thread starter Thread starter JeanRNorman
  • Start date Start date
J

JeanRNorman

I am just learning Access, and I am unable to get a Form to work with my
database. I get an error, "The wizard is unable to open your form in Form
view or Datasheet view, possibly because another user has a source table open
in exclusive mode." I am the only one working on this database, which is
brand-new. I found one Help article that said if a "reserved word" was used,
that could cause a problem like this, and I had done that on my first try.

I created the form based on two tables, "Facilities" and "Activities", that
are in a one-to-many relationship ("Facilities" is the many, "Activities" the
one).
I deleted that database and started a fresh one with the same name but not
using that reserved word, thinking that would fix the problem. It has not.
I cannot enter data in fields bound to the "Facilities" table, but I can to
fields bound to the "Activities" table. When I try to type in the
"Facilities"-bound fields, I get a brief message at the bottom of the screen
that says, "join key of Facilities not in record set."

Can you help?
 
On Fri, 14 May 2010 16:12:01 -0700, JeanRNorman

They don't tell you this, but especially as a beginner you should
follow the paradigm: one form, one table.
In this case, the main form is bound to the Activities query, and if
you have a subform, it should be bound to the Facilities table.
Rookies sometimes think one of these should be bound to a join of
parent and child table. Not so. The relationship is expressed by
setting the LinkParentFields and LinkChildFields properties. The
control wizard can help you with this.

-Tom.
Microsoft Access MVP
 
Back
Top