Help! controls disappear

I

IceTy

I have form that is based on a query. When there are no records, the form
does not show any control when it is opened. When there is at least one
record the controls do appear. Can someone please help with this mystery or
explain what is happening?

Thanks
 
R

Rick Brandt

IceTy said:
I have form that is based on a query. When there are no records, the form
does not show any control when it is opened. When there is at least one
record the controls do appear. Can someone please help with this mystery or
explain what is happening?

Thanks


When you see a blank form that still displays all of the empty fields it is when
the form is positioned at the NewRecord position. When a form is based on a
Query that doesn't allow new records there is no NewRecord position and the
detail section appears completely blank unless it has existing records to show.
 
K

Ken Snell

Rick Brandt said:
When you see a blank form that still displays all of the empty fields it is when
the form is positioned at the NewRecord position. When a form is based on a
Query that doesn't allow new records there is no NewRecord position and the
detail section appears completely blank unless it has existing records to
show.

Or the form's AllowAdditions property is set to No.
 
I

IceTy

Thanks guys, I have tested your suggestion and now my problem is solved.

Thanks again
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top