I have a new Access2003 application that I am delivering to customers. One of the forms is bound to a table that starts out with no records.
Not all users are able to insert new records into this table so I would like to have the form start up with allowAdditions set to False. However, if I do this then all of the controls are missing.
Is there an easy around this? I have looked at similar questions, but noone seems to be able to answer this. The things that I have thought up, all of which are a lot of work for a seemingly simple request are:
1) Stick a bogus record in the table and hope it doesn't confuse anyone ... but it will.
2) Stick my current form as a subform into an unbound main form that contains all the controls. But then the subform is still completely blank when nothing is there, and it means I have to use all of that annoying subform syntax to get at my controls.
3) Create two forms, one bound and one unbound, on two separate tab pages. Then depending on whether or not there is a record in the table show one page and hide the other.
4) Get Bill Gates to rewrite Access2003.
Any better ideas?
Start Free Trial