Form based on query - need to see blank records

[dazstarr]

Hi

Can someone help me please?

I have a form based on a query. The query has 5 related tables in. The main table in my database is called contracts. If there are no records in the contracts table - when I open the form - it just displays blank.

Can someone advise me of a work around to display a blank record?

Many Thanks
Daz

 

[namliam]

YOu have to change your join type from "inner" join to "outer" join.

Double click the line you have between your tables and select the type you want/need.

Note:
This is a one way street... Assume we have 3 tables, a, b and c
= Inner join
> Outer join

1) a = b = c
2) a > b = c
3) a > b > c
4) a = b > c

Option 2 is invalid, you cannot do this "half way", options 1,3 and 4 are valid.
4 is valid because there is no inner join after the outer join, where by 2 the outer join happens before the inner.

Hope this is enough info.

Good luck.

 

[dazstarr]

Thanks for your response - I will see if I can get it working.

Thanks again

Daz

 

[darbid]

If there are no records in the contracts table - when I open the form - it just displays blank.

in case namliam suggestions do not help. You don't by chance have Allow Additions = False

 

[dazstarr]

Hi

Thanks for your reply - no it is set to allow. I checked that earlier on.

The form only displays when there is a record in the contract table and a related record from the other table.

Daz

 

[missinglinq]

My only guess, which is what the mailman is referring to, is that the query which your form is based on is a Read-Only query. If the query is Read-Only, no new record can be added and a form that is based on a Read-Only query shows up completely blank when no records are present. To see if this is the case, from the Objects Dialog box go to Queries and click on the query that your form is based on to open it. Now try to enter a new record directly into the query. If you're unable to do so, this is the cause of your problem.

If your query is Read-Only, follow this link to Allen Browne’s article explaining the reasons this happens.

http://allenbrowne.com/ser-61.html

As you'll see from Allen's article, the Join type is just one of a number of things that can affect this.

 

[dazstarr]

Bingo!!

Thanks for that - it was because I had Group By enabled (can't remember why now).

Thanks for your help!

Daz

 

[missinglinq]

Glad we could help!