Data bound conrols

[Nakul]

Hi,

I have bound my access form to Query that does might and might not return
records. All my controls on the form are bound to the fields of the Query.
The problem is that if there are no records the form is displayed blank and
controls are missing. It does not give an option of adding new record.

Any help would be appreciated

Thanks
Nakul

 

[Allen Browne]

This happens when no new record can be added.

Can you add a new record directly to the query?
NO: The query is the problem. Change it so it accepts new records.
YES: The form is the problem. Check its AllowAdditions property.