Form only saving half of information

[NealeBabb]

I have a call log database to record calls i make and recieve,
the form in question cantains info from two tables tbl_Caller and tbl_Call, tbl_Caller containing all the caller information eg company name, contact name etc. and tbl_Call containing the time and date of the call and what was said, it is pretty simple in its construction, but i am having trouble with saving,
Sometimes there is a blank record when i have previously logged a call and other times there is only half of what was written saved,
If it does save something and is not completly blank it manages to save the Caller information, and the date and time of the call but the memo field containing the call information is cut short

this may be simple but is quite large, containing 17733 calls, dont know if this may be contributing to the problem

I have looked and cant find any patterns to when or why this is happenening

Does anyone have any ideas on what is causing this and how to solve it,

if you need any more information please let me know and i will provide what i can

Thanks

 

[pr2-eugin]

A bit more information as in is the form built on a Master form/Sub form structure? Is there any methods that are involved while updating, that might cut your data, like Form_BeforeUpdate/ MemoControl_AfterUpdate?

 

[NealeBabb]

I have 2 tables
tbl_Caller and tbl_Call

tbl_Caller contains fields
RefNum - Text - Primary Key
CompanyName - Text
Contact - Text
Postcode - Text
Comments - Memo

tbl_Call contains fields
ID - Autonumber - Primary key
RefNum - Text
Date - Date / Time
Time - Date / Time
Category - Text
CallLog - Memo

I have a query contiaing all fields from both tables and linking RefNum from the two,

The form is basic. i run a form wizard on the query and just clicked finish and just moved the boxes around on the form to make it easier to use.

I added 2 drop down boxes, one which contains a list of categorys, nothing special about that, and another which contains all entries in RefNum field in tbl_Caller and filters the form by RefNum. Code below but i dont thing that this is the problem as it works

Dim strfilter As String

If Me.ComboRefNum = "" Then
Me.FilterOn = False
Me.ComboRefNum.SetFocus
Exit Sub
End If
strfilter = "RefNum Like '*' & '" & Me.ComboRefNum & "' & '*'"
Me.Filter = strfilter
Me.FilterOn = True

This is pretty much it. the only reason i made this is because i dont have the best memory and trying to remember 30+ phone calls a day was a bit of a pain so just needed something simple to them

really need help sorting this as it seems like the calls that are going missing contian the important information i need

and ideas would be greatly appriciated

Thanks

 

[CJ_London]

Hi,

I think this line: strfilter = "RefNum Like '*' & '" & Me.ComboRefNum & "' & '*'"
should be presented as strfilter = "[RefNum] Like '*" & Me.ComboRefNum & '*'"

not sure if it solves your problem, but looks like an error anyway!

 

[NealeBabb]

Hi,

I think this line: strfilter = "RefNum Like '*' & '" & Me.ComboRefNum & "' & '*'"
should be presented as strfilter = "[RefNum] Like '*" & Me.ComboRefNum & '*'"

not sure if it solves your problem, but looks like an error anyway!

as far as i know square brackets are only required if the field contains a space in it, i may be wrong but the filter works fine without them

 

[pr2-eugin]

Hi, I am unable to recreate your problem.. is it possible for you to upload a stripped down version of your DB for us to look at?

 

[NealeBabb]

I have attach a copy of the database, had to remove all information from tables as contained sensitive information.

 

[CJ_London]

as far as i know square brackets are only required if the field contains a space in it, i may be wrong but the filter works fine without them

Hi Neal,

I tend to use square brackets as much to highlight it is a field name to make it a bit more readable. Agree actually only required when there are spaces. However it was the '*' & '" & bit I was referring to but if that is working OK, it's kind of irrelevant anyway!

 

[NealeBabb]

Hi Neal,

I tend to use square brackets as much to highlight it is a field name to make it a bit more readable. Agree actually only required when there are spaces. However it was the '*' & '" & bit I was referring to but if that is working OK, it's kind of irrelevant anyway!

I copied this code from another database i made and was a lot more complicated, and it just ended up like this after i finished messing with it, but as you said so long as it works.

 

[CJ_London]

Without any data to demonstrate the problem it is a bit difficult to advise. But a couple of things to try:

Change the recordtypeset from Dynaset to Dynaset(inconsistent updates) in the form properties.

Another suggestion is to put the tbl_call data into a subform and set the master and child links to refnum. Masterform would only have the tbl_caller table as a recordsource

 

[NealeBabb]

CJ_London

Have made the changes you have suggested, will test it and see if it solves the problem, thanks