Need Help with Subforms

[Jeremiah J. Burton]

I am trying to create a database (in Acces 2000) to track my fossil
collection. I have a main table that has records for every specemen. I
have a secondary table with information on localities that the specimens
were collected at. The tables are linked. Each record in the specimen
table will link to only 1 record in the locality table, however each
locality can be linked to multiple specimens.

I am trying to create a form (based on the specimen table) that will
have a subform showing the locality information. I'd like to set it up
so that if I am adding a new specimen I can select and existing locality
to link it to , or add a new locality from a subform. What is the best
way for doing this?

I created a combobox on the main form that allows me to select a record
from the locality table to link it to, and it works fine, but it is a
little messy. However, when I try to type a new record in on the
locality subform I get an error that says "You can;t assign a value to
this object" " The object may be a control on a read only form" Also
when adding a new specimen, the add new record button on the locality
subform is greyed out.

Is there something I need to do to be able to add records via the
subform, or is there a problem with my table relationships?

thanks

jjb

[Danny J. Lesandrini]

It's hard to say what's going on without seeing the form, but here are
a couple places to look:

First, does the subform allow additions? edits? deletions?
(these are properties of the form in design view)

Second, did you set the Master/Child field for the subform
object? Click the subform object and check these properties.

Finally, is the recordset for your subform updateable? Open the
query and try to add a record. There are a number of reasons
why a query is not updateable.
--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com
"Jeremiah J. Burton" <jb*****@nospamhewittenergygroup.com> wrote in message
news:7b******************************@news.teranew s.com...

I am trying to create a database (in Acces 2000) to track my fossil
collection. I have a main table that has records for every specemen. I
have a secondary table with information on localities that the specimens
were collected at. The tables are linked. Each record in the specimen
table will link to only 1 record in the locality table, however each
locality can be linked to multiple specimens.

I am trying to create a form (based on the specimen table) that will
have a subform showing the locality information. I'd like to set it up
so that if I am adding a new specimen I can select and existing locality
to link it to , or add a new locality from a subform. What is the best
way for doing this?

I created a combobox on the main form that allows me to select a record
from the locality table to link it to, and it works fine, but it is a
little messy. However, when I try to type a new record in on the
locality subform I get an error that says "You can;t assign a value to
this object" " The object may be a control on a read only form" Also
when adding a new specimen, the add new record button on the locality
subform is greyed out.

Is there something I need to do to be able to add records via the
subform, or is there a problem with my table relationships?

thanks

jjb

[Jeremiah J. Burton]

The subform allows additions, deletions, and edits

The Child field is set to a filed on the specimen table. The master
field to one on the locality table

The locality table is updateable.

Check you hotmail account, I e-mailed you a zip of the access file

thanks for the help

"Danny J. Lesandrini" <dl*********@hotmail.com> wrote in news:bqqra9
$2*******@ID-82595.news.uni-berlin.de:

It's hard to say what's going on without seeing the form, but here are
a couple places to look:

First, does the subform allow additions? edits? deletions?
(these are properties of the form in design view)

Second, did you set the Master/Child field for the subform
object? Click the subform object and check these properties.

Finally, is the recordset for your subform updateable? Open the
query and try to add a record. There are a number of reasons
why a query is not updateable.

[Bob Quintal]

"Jeremiah J. Burton" <jb*****@nospamhewittenergygroup.com> wrote in
news:51******************************@news.teranew s.com:

The subform allows additions, deletions, and edits

The Child field is set to a filed on the specimen table. The master
field to one on the locality table
But you said originally the Parent form was the specimen table and the
Child table was the locality table. This might be the problem,

The locality table is updateable.

[Danny J. Lesandrini]

Jeremiah had two controls on the master form pointing to the
Master Link Field, LocalID. One was a textbox and another
was a combo box. Deleting the combo box fixed the problem.
--
Danny J. Lesandrini
dl*********@hotmail.com
http://datafast.cjb.net

"Jeremiah J. Burton" <jb*****@nospamhewittenergygroup.com> wrote in message
news:51******************************@news.teranew s.com...

The subform allows additions, deletions, and edits

The Child field is set to a filed on the specimen table. The master
field to one on the locality table

The locality table is updateable.

Check you hotmail account, I e-mailed you a zip of the access file

thanks for the help

"Danny J. Lesandrini" <dl*********@hotmail.com> wrote in news:bqqra9
$2*******@ID-82595.news.uni-berlin.de:

It's hard to say what's going on without seeing the form, but here are
a couple places to look:

First, does the subform allow additions? edits? deletions?
(these are properties of the form in design view)

Second, did you set the Master/Child field for the subform
object? Click the subform object and check these properties.

Finally, is the recordset for your subform updateable? Open the
query and try to add a record. There are a number of reasons
why a query is not updateable.