Subform not allowing data entry

[waters27863]

I have a database that I am creating to allow an organization to track alarm
activations. I have used the forms wizard to create the f_alarm_info
subform, and f_POC_info main form. The problem I'm running into is that I
can input data into the main form, and into some of the fields of the
sub-form. Any field pertaining to the table t_alarm_info will not allow data
input.

Below is a link to my google docs which has pdf's of the tables'
relationships, and the documenter output. I'm pretty sure I have something
off with the relationships that will not allow me to enter data into the
subform created by the wizard.

http://docs.google.com/leaf?id=0BxKWJF7gFXOtNmEyZjQ1ZTgtYmQwYi00ZjAzLWJkNzUtNmQ2NmY5YzdiZDNk&hl=en

 

[golfinray]

Have you set the master and child fields? Click on the box containing the
subform and check those. Also make sure that the table the subform is based
on is editable.

 

[waters27863]

Golfinray,

I'm not sure what you mean by master and child fields. I have very little
form design experience as I usually use the wizard.

 

[waters27863]

Gofinray,

I checked the properties of the master and child fields. They both point
to: PoC_Auto_ID.

 

[golfinray]

Is that an autonumber? If so do the autonumbers of both tables match the same
data? If they don't, your subform will not work properly. Also check and make
sure that the table that feeds the subform is editable ( the arrow and
asterisk at the bottom are highlighted.)

 

[Jason Lev]

"Also check and make
sure that the table that feeds the subform is editable ( the arrow and
asterisk at the bottom are highlighted.)"

What are you referring to here? I am using Access 2007 with a SQL Server 2008 backend.




golfinray wrote:

Is that an autonumber?
10-Dec-09

Is that an autonumber? If so do the autonumbers of both tables match the sam
data? If they do not, your subform will not work properly. Also check and mak
sure that the table that feeds the subform is editable ( the arrow an
asterisk at the bottom are highlighted.
-
Milton Purd
ACCES
State of Arkansa

:

Previous Posts In This Thread:

Subform not allowing data entry
I have a database that I am creating to allow an organization to track alar
activations. I have used the forms wizard to create the f_alarm_inf
subform, and f_POC_info main form. The problem I am running into is that
can input data into the main form, and into some of the fields of th
sub-form. Any field pertaining to the table t_alarm_info will not allow dat
input

Below is a link to my google docs which has pdf's of the tables
relationships, and the documenter output. I am pretty sure I have somethin
off with the relationships that will not allow me to enter data into th
subform created by the wizard

http://docs.google.com/leaf?id=0BxKWJF7gFXOtNmEyZjQ1ZTgtYmQwYi00ZjAzLWJkNzUtNmQ2NmY5YzdiZDNk&hl=en

Have you set the master and child fields?
Have you set the master and child fields? Click on the box containing th
subform and check those. Also make sure that the table the subform is base
on is editable
-
Milton Purd
ACCES
State of Arkansa

:

Golfinray,I am not sure what you mean by master and child fields.
Golfinray

I am not sure what you mean by master and child fields. I have very littl
form design experience as I usually use the wizard

:

Gofinray,I checked the properties of the master and child fields.
Gofinray

I checked the properties of the master and child fields. They both poin
to: PoC_Auto_ID.

Is that an autonumber?
Is that an autonumber? If so do the autonumbers of both tables match the sam
data? If they do not, your subform will not work properly. Also check and mak
sure that the table that feeds the subform is editable ( the arrow an
asterisk at the bottom are highlighted.
-
Milton Purd
ACCES
State of Arkansa

:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Essential ASP.NET with Examples in VB.NET
http://www.eggheadcafe.com/tutorial...4c-e77501d4a63b/essential-aspnet-with-ex.aspx