Help! Form not working.

Hi,

I just divided a very large table into 3 smaller tables. I believe I have
setup the relationships correctly. I'm using a form/subform to enter the
data. The subform uses command buttons to open a form with more details.
The records that were entered prior to the table conversion is totally
accessable, but when I try to enter a new record the form will not allow any
information to be entered.

Does any one have ideas?

TIA,

Richard

On Mon, 14 Jun 2004 20:06:59 -0700, "Richard Wright"
wrote:

Hi,

I just divided a very large table into 3 smaller tables. I believe I have
setup the relationships correctly. I'm using a form/subform to enter the
data. The subform uses command buttons to open a form with more details.
The records that were entered prior to the table conversion is totally
accessable, but when I try to enter a new record the form will not allow any
information to be entered.

Please post the SQL view of the two forms' Recordsources, the
subform's Master/Child Link Fields, and the error message that you're
getting.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Hi John,

Thanks for the help. I do not know or understand what you mean by sql view
of the two forms' recordsources, but if you will tell me how to obtain it I
be happy to provide the info. The subform's master/child link fields are
both set to AddressID. I do not receive an error message, the called form
just displays with the cursor blinking in a field, but doesn't accept any
input.

My table breakdown is as follows:

Table: Address Table: Customers
Table: RoofInfo
----------------------------------------------------------------------------
---------------------
PK: AddressID PK: CustomerID
PK: RoofID
Common Field:
AddressID
Common Field:
RoofID

Relationship: Tbl:Address/AddressID One to Many with
TBL:Customers/AddressID and Tbl:Customers/RoofID One to One with
Tbl:RoofInfo/RoofID.

My Master Form's recordsource is the address table. The child form's record
source is the customers table. On the child form I have to cmd buttons.
One button opens a form called customer that allows more details to be
entered and it's record source is a query combining info from all 3 tables.
The second cmd button opens a form called roofinfo which allows details
about a properties roof to be entered. This form's record source is the
same query.

What I am trying to do: I need to track a single property address that
might have multiple customers, with each customer linked to the same roof,
but with different types of info about the roof for each customer.

My Master form shows the address and date the property was entered into the
database (stored in the address table) . The child form shows the contact
name, company and scheduled date of inspection. The user will then select
either the button to enter more details about the customer or the button to
enter details about the property's roof.

I can view/edit data that was previously entered and I can enter new data in
the master/child forms, but when I try to enter new data in the forms
called by the cmd buttons nothing is accepted. FYI - I've noticed that the
primary key fields for the tables address and customers is updated when I
enter data into the master/child forms, but the primary key field in the
roofinfo table is not when I open the roofinfo form.

TIA,

Richard

I hope this clears up what I'm trying to do.
"John Vinson" wrote in message
...
On Mon, 14 Jun 2004 20:06:59 -0700, "Richard Wright"
wrote:

Hi,

I just divided a very large table into 3 smaller tables. I believe I
have
setup the relationships correctly. I'm using a form/subform to enter the
data. The subform uses command buttons to open a form with more details.
The records that were entered prior to the table conversion is totally
accessable, but when I try to enter a new record the form will not allow
any
information to be entered.

Please post the SQL view of the two forms' Recordsources, the
subform's Master/Child Link Fields, and the error message that you're
getting.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public