form display

Q

qaman

I designed a form that has a parameter query as a record source. If there
is no data for the query selection the empty form doesn't display for some
users, instead a blank access screen shows. For some users with different
permissions the form does display and shows no data (which is what I want).
I believe this could be related to permissions. Is this possible?
 
R

Rick Brandt

qaman said:
I designed a form that has a parameter query as a record source. If
there is no data for the query selection the empty form doesn't
display for some users, instead a blank access screen shows. For
some users with different permissions the form does display and shows
no data (which is what I want). I believe this could be related to
permissions. Is this possible?
Click to expand...

A Form with no data in its RecordSet will only show a set of empty controls
if the Form and its RecordSet allow new records to be entered. This is
because the view you see of empty controls is actually the new record
position in the form's RecordSet.

If anything disallows new records to be inserted then the details section of
the form will appear completely blank. If some of your users do not have
permissions required to add records then they would get a blank form
display.
 
O

Ofer

If the users has no permission to add data to the table, tha blank line wont
apear in the form, and they will get the blank screen.

The empty line that the other users get, will let them enter a new record to
the table via the form.
 
Q

qaman

Makes sense, thanks a lot

Ofer said:
If the users has no permission to add data to the table, tha blank line wont
apear in the form, and they will get the blank screen.

The empty line that the other users get, will let them enter a new record to
the table via the form.
Click to expand...
 
Q

qaman

Sounds logical, thanks.

Rick Brandt said:
A Form with no data in its RecordSet will only show a set of empty controls
if the Form and its RecordSet allow new records to be entered. This is
because the view you see of empty controls is actually the new record
position in the form's RecordSet.

If anything disallows new records to be inserted then the details section of
the form will appear completely blank. If some of your users do not have
permissions required to add records then they would get a blank form
display.
Click to expand...
 
Top