Hi,

why do ALL form items disappear if certain records are not there? my mainform is fed by a people Qry and the people have payments however, if you delete the payments, all of the items on the mainform disappear. if i go into the table and manually add a payment, everything re-appears.
the mainform is exclusive to "peopleQry" and there are 2 subforms which show different data at different times. when the form loads, these subforms have a sourceobject set to "" so it couldnt be them. the mainform doesnt display any payment information unless asked and then, it is shown on a different form. this is a bit of a problem now.

can it be prevented?

regs,

NS

Nigel,

Get your query in Design View and right-click on the line joining your
two tables. You probably have an Inner Join now, retrieving data only
when there are values in ALL tables.

Change it so that it says "Include All records from YourMainTable"

That should do it.

Wayne

Hi,

why do ALL form items disappear if certain records are not there? my mainform is fed by a people Qry and the people have payments however, if you delete the payments, all of the items on the mainform disappear. if i go into the table and manually add a payment, everything re-appears.
the mainform is exclusive to "peopleQry" and there are 2 subforms which show different data at different times. when the form loads, these subforms have a sourceobject set to "" so it couldnt be them. the mainform doesnt display any payment information unless asked and then, it is shown on a different form. this is a bit of a problem now.

can it be prevented?

regs,

NS
This link (http://www.allenbrowne.com/casu-20.html) may give you some helpful info about your problem

if you have a non updateable query, or a form with allow additions=false, and you have NO records, then there is no detail section - its not that the controls are null, they just arent there, and trying to test them with code produces an error - i bet thats what you are seeinig

hey rabbie everything is there u have to see by heart