Sub Form Showing Nothing

[rob.low]

Hi There
I cant work out were I am going wrong ... heres whats happening

I have a form called "clients" and data is stored in table "clients"
Also on that form is a sub form called "contacts" and data is stored in table "Contacts"
Parent and child are linked with a field named "idno"

What happens is this when i go to a record and the sub form "contacts" has data it shows OK
but if the sub form "contacts has no data nothing shows i cant even add a new record, the form shows up blank

Any help with this would really be appreciated

thanks
rob

 

[Rich]

Are the joins the correct way around?

 

[boblarson]

Make sure that the subform AND the main form have AllowAdditions set to YES.

 

[rob.low]

Thanks for the replys

i have the joins set up ok as if there is data in table contacts then it shows ok in the subform contacts
if i can ill explain some more

if i go to a client record and there is no data (record) for that client in the contacts table the subform contacts shows up blank (no fields or the button to edit and add new records)

thanks for the help

rob

 

[rob.low]

ok guys now sorted
thanks for all your help on this

regards
rob

 

[boblarson]

ok guys now sorted
thanks for all your help on this

regards
rob

What was the final fix? If you don't mind (it could help someone else later)

 

[rob.low]

What was the final fix? If you don't mind (it could help someone else later)

Hi Bob

You were right as usal lol I spent hours on this

I had AllowAdditions set to no .. there for not letting the database create a new record and the form showd nothing just blank

Hope this helps someone else
thanks for your help Bob

rob

 

[David Eagar]

Don't you just hate it when Access does exactly what you tell it?

 

[rob.low]

Don't you just hate it when Access does exactly what you tell it?

loll say no more loll