W
WembleyBear
Hi
I have a database for recording details of our service calls, in which one
form is for entry of details relating to the call including a memo field for
Problem History. This field is not set to allow direct data entry on the
form, but I have a button which calls a pop-up form to allow a user to record
notes. Then I used the After Update property of the text box on the pop-up
form to call a SetValue macro to record the new note along with date and time
stamp into the Problem History field, above any notes that are there already.
This appears to work, but the problem I have is that after additional notes
are entered, another blank record is inserted into the main Calls table,
although the note in the Problem History field display correctly. Once 3 or 4
notes have been added, there are an extra 3 or 4 apparently blank records in
the Calls table. Where is it going wrong and what can I do to stop this from
happening?
Martyn
Access 2000
Windows 2003 Server over Citrix PS
I have a database for recording details of our service calls, in which one
form is for entry of details relating to the call including a memo field for
Problem History. This field is not set to allow direct data entry on the
form, but I have a button which calls a pop-up form to allow a user to record
notes. Then I used the After Update property of the text box on the pop-up
form to call a SetValue macro to record the new note along with date and time
stamp into the Problem History field, above any notes that are there already.
This appears to work, but the problem I have is that after additional notes
are entered, another blank record is inserted into the main Calls table,
although the note in the Problem History field display correctly. Once 3 or 4
notes have been added, there are an extra 3 or 4 apparently blank records in
the Calls table. Where is it going wrong and what can I do to stop this from
happening?
Martyn
Access 2000
Windows 2003 Server over Citrix PS