As part of a helpdesk system I want users to be able to log calls. I have a helpdesk staff switchboard and as part of it I want a button that when clicked will direct the user to a NEW RECORD in a form called "Calls". I think this might have something to do with the DataEntry property in VB. I tried creating a command button using a wizard and then adding DataEntry = True but it didn't work. Does anyone know how to code such a button or what to add to a wizard button code or to specify as the criteria for an OpenForm macro which will do this?
Also, does anyone know how I can get data in a textbox to be dynamic and saved (ie. if you open a form and enter a value in it it will remain there when it is closed) without setting it as the control source or default value of the textbox (then if you update it from the form view the value isn't saved) or linking it to a value in a table? I have a procedure that looks at the value in that textbox and if another value is greater it changes the colour of other controls etc. The value in the textbox I am talking about must be updatable and can't have a default value.
Thanks!
Also, does anyone know how I can get data in a textbox to be dynamic and saved (ie. if you open a form and enter a value in it it will remain there when it is closed) without setting it as the control source or default value of the textbox (then if you update it from the form view the value isn't saved) or linking it to a value in a table? I have a procedure that looks at the value in that textbox and if another value is greater it changes the colour of other controls etc. The value in the textbox I am talking about must be updatable and can't have a default value.
Thanks!
