grid has disapeared from sub form

[John thomas]

Hi just launched my data base after much testing and all seemed ok
However Its gone wrong
I have a orders sub form that was working great .Then all of asudden when i whent to input information into the fields i realised the grid under variuos field names has disappered (Icant enter any info),surly this must be something i have accidently done without realising
Please help I am New so keep it all simple
Many thanks john

 

[Trevor G]

First check your relationships and then check the properties of the subform to see if child and master settings are pointing to the correct fields You check this out on the main form in design view) you have in the relationships and do you have records that you can view to check it out?

 

[boblarson]

If the parent form has its AllowEdits property set to NO then you can't edit the subform either. If the subform's record source is non-updateable and there are no existing records, it won't appear. If there are no records in the subform's record source and the Allow Additions is set to NO, it won't appear.

 

[John thomas]

Many thanks guys
I dont think it can be any of those becouse i would have had to have changed something in the property sheet?I think
The form was workink ok after entering 2 records usually new is displayed in the next line down this iswhat is not happening .I did look in the details table prior and played abought with yes no fields Co

 

[boblarson]

Many thanks guys
I dont think it can be any of those becouse i would have had to have changed something in the property sheet?I think

Did you look? Remember what the word ASSUME breaks down to.

The form was workink ok after entering 2 records usually new is displayed in the next line down this iswhat is not happening .I did look in the details table prior and played abought with yes no fields Co

If you need to, post your database and we'll take a look. Remember to run compact and repair first and then zip the file if you do.

 

[John thomas]

Thanks Bob you are of course rite.
However i have now noticed that if i try to alter the sub form in design made.I get a message saying something like the data base canot get a lock .
Is this the problem
Many thanks

 

[boblarson]

Do you have any of the same tables that are being used as the subform's record source in the main form's record source too? That can cause problems if so. There is almost never a need to have the same tables in those.

 

[John thomas]

Bob if i am understanding you
I have a table orderdetails.These records show in the order details form and the sub form fields are also in the order details

 

[boblarson]

That could be your main problem. They should not share the same tables in the recordset. Normally, for orders, you would have an Orders table which has fields for storing things that are applicable to the entire order. That would be the main form's record source. Then you have the Order Details table which would not store things like the orderID, OrderDate, etc. because those are things that are applicable to the entire order. The order details is just that. What items are being ordered, what their price is, how many of them, etc. Only those things that are applicable to each line item of the order.

So the Orders table would form the main form and the Order Details table would make up the record source of the subform.

Does that make sense?

 

[John thomas]

Hi Bob that makes perfect sense
Its back to the drawing bd and start again
Many thanks for your help and thanks for keping it easy to understand
John

 

[boblarson]

Just a point of clarification. The Order Details would have OrderID in it as that would be the tie for each detail record to the Orders table. Check out the Northwind Sample database from Microsoft to see an Orders/Order Details table set up and form/subform.

 

[John thomas]

Hi Bob I will do that
Currently on my oderdetaild sub form as well as having the products ordered ect i also continue with fields that say for EG ordered wth supplier who took order and date order placed and chec boxes for order placed and order in stock .Should this information not be stored here and if so were do i put it I want to keep my data base simple as poss we are a very small company and i do all the ordering form t

 

[boblarson]

Yeah, the "who took the order" and date order placed and the other info you mentioned should be in the ORDERS table and not the Order Details table. The way you know that is that if you would be entering that info for each record for that same order then it should not be in that same table but in one that has only one record for each order.

 

[John thomas]

Hi Bob checked out North wind Very informative but i cant see the orders form on the left hand side can see the table
and i have had a good look at the relationships thats also very helpfull