got_access:]
Registered User.
- Local time
- Yesterday, 20:03
- Joined
- Jun 15, 2018
- Messages
- 83
Hi all,
I've got a friend who has asked me a question about an Access system.
I don't have access to this system myself to look at it - so I can only describe.
The issue is a form in which there is a control field which either provides a drop-down list or simple data entry. The data value this control is supposed to hold is a year value. So the user would select "2019" for example or type it in.
From what I'm told - on save - this control does not actually insert the year value into any table. The user is then forced to go to the actual table and find the new record and insert the year value.
I know there can be controls on forms that are not BOUND to any data source and this YEAR field may have been designed to perform some calculation rather than to insert a value.
But is there a possibility that this control was intended to insert a value into a table and at some point a user perhaps inadvertently switched one of the control's properties off - which would allow it to perform the insert?
I'm trying to remember what property of the control this would be?
Any suggestions would be greatly welcome
Thanks
I've got a friend who has asked me a question about an Access system.
I don't have access to this system myself to look at it - so I can only describe.
The issue is a form in which there is a control field which either provides a drop-down list or simple data entry. The data value this control is supposed to hold is a year value. So the user would select "2019" for example or type it in.
From what I'm told - on save - this control does not actually insert the year value into any table. The user is then forced to go to the actual table and find the new record and insert the year value.
I know there can be controls on forms that are not BOUND to any data source and this YEAR field may have been designed to perform some calculation rather than to insert a value.
But is there a possibility that this control was intended to insert a value into a table and at some point a user perhaps inadvertently switched one of the control's properties off - which would allow it to perform the insert?
I'm trying to remember what property of the control this would be?
Any suggestions would be greatly welcome
Thanks