Table data entry

[Pedro]

Hello! I am close to finishing the forms to my database but still trying to
wriggle out the little glitches. I have a main form that is mostly used to
view data, and the user is then given the option to update the data in this
form by clicking a command button that takes them to another form. This new
form has various command buttons to open up various other data entry forms
(its a novice database to say the least!) Four out of the five forms in this
section allow data entry without any difficulty, but one of them refuses to
allow any new records to be added. I noticed that if i close the main form
(the form that displays all the relevant data), the form allows me to add new
data. Any clues as to what is causing this, and a work around? Thanks in
advance!

 

[John Vinson]

I noticed that if i close the main form
(the form that displays all the relevant data), the form allows me to add new
data. Any clues as to what is causing this, and a work around? Thanks in
advance!

Might the two forms have the same table as their Recordsource? If you
have a record open on FormA, and attempt to edit that same record
using FormB, the attempt will fail with a message about "another user
already has the record open".

What are the recordsources for these forms? Have you tried using a
Form with Subforms (a typical technique for one to many relationships)
rather than popup forms? What error message are you getting, and what
*are* the Recordsources of these forms?

John W. Vinson[MVP]
(no longer chatting for now)

 

[John Vinson]

hey thanks for replying. the main form i was talking about is related to a
user table, with a combo fox for selecting names. when a name is selected,
the two subforms (one of which has a subform within it as well), update with
the details. one of these subforms does display the information that is
related to the troublesome data entry form. what i dont get is that the other
subforms on the main form have no trouble with their data entry forms, its
only this one.

the reason i have used the pop up forms is because i have quite a few many
to many relationships within the database's structure, and i wasn't quite
sure on how to create an advanced form for these kind of relationships. it
seemed a lot easier to have a series of forms that were related directly to
their subsequent tables. maybe you have a better system for setting this kind
of situation up?

there is no error message arising, the new record button is simply not
activated, its there but has been faded out so that it cant be used. any
help you could provide would be greatly appreciated. thanks

This symptom means that the Query upon which the form is based is not
updateable. Try opening the query directly - does it have a *> new
record line? (I'd guess it doesn't). The Query should NOT join all
three tables! If you need help figuring out why it's not updateable,
please post the SQL text of the query here.

Subforms based on the many-to-many resolver tables are in fact the
typical way to handle this issue. You can do it with popup forms but
it's a lot more work!

John W. Vinson[MVP]
(no longer chatting for now)

 

[Pedro]

the form is not based on a query, its based on a table, and you are right,
the actual table doesn't have the new record button. This table is the
junction table in one of the many to many relationships. all i need to do on
the form is to make a selection in two combo boxes that relate the two other
tables to one another.

i wasn't able to find any detailed information on how to utilise subforms in
a many to many relationship. i found some example databases on the net but
they didn't really explain the process to me. do you know of anywhere on the
web where i can find this type of material? im a novice with this program,
but unfortunately im stuck in a little village in the heart of europe and its
difficult to find english novels let alone a decent access textbook!!!