Calling a child form

[Guest]

I have two forms, patients and observations. Both are based on two different
tables and were made using wizards. Both corresponding tables are parent and
child in database. I am calling observation form from patient using OpenForm.
It has a where clause to display only related records, but the new patients
who don't have observations yet, it displays a totaly blank form with out any
fields to enter data. What I want is to have observations form with all
fields but without data in them as there would be nothing in corresponding
table and user can add a new record.

Thanks in advance

 

[Allen Browne]

The Detail section of your form will show completely blank if both these are
true:
a) There are no records to display, and
b) No new records can be added.

Obviously (a) applies.

(b) could apply if:
- The form's AllowAdditions property is set to Yes, or
- The form's RecordSource (a query?) is read-only.

 

[Guest]

First thanks for replying.
In my case the first scenario is right and want to show the user all fields
so that he can add one now. Is there any option for this.

Rashid

 

[Rick Brandt]

First thanks for replying.
In my case the first scenario is right and want to show the user all
fields so that he can add one now. Is there any option for this.

Rashid

Is your form bound to a query? Not all queries are updateable. If the query
does not allow new records to be added then the form won't either.

 

[Debbie]

How do you make a query not read only?

 

[John Vinson]

How do you make a query not read only?

See "Updateable" in the online help. Queries are updateable to start
with, but there are many things you can do which "break" updatability;
these include:

- a two-table query must have a unique Index in the one side join
field
- No Totals query, or any query including any totals operation, is
ever updateable (even if logically it seems like it should be)
- No UNION query or DISTINCT VALUES query will be updateable
- Too many tables in a query can block updating

John W. Vinson[MVP]