I have a bound form that first opens in “view mode” (i.e. AllowAdditions, AllowEdits, and AllowDeletions are all FALSE). This works fine when the underlying table has data in it; but when it doesn’t (i.e. no records for the primary key), the form opens up with no controls visible at all in the detail section. The detail section is totally blank. I would like for the form to open with the controls visible even though there are no data and all the fields would be blank.

Are there any other options besides opening the form in “edit mode” and just locking all the fields (which needs code to loop through all the controls to set their Locked properties to False vs. one simple command like Me.AllowEdits = False)?

__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division

I think what you are suggesting is the way to go:

Dim C as Control

For each C in Me.Controls
    C.Locked = True
    C.Enabled = False
Next C

I think that would work - the user could not change anything, but would not get an empty form.

Another suggestion is to set AllowAdditions to TRUE but not let the user navigate to a new record. It's the AllowAdditions to FALSE that's causing the problem. :(