Forms based on a query doesn't record the infos

[Grooz13]

Ok i have a complexe query with 3 tables that link the first with the second using 2nd link type and the second with the third using the 3rd link type

now everything is fine but only one thing bothers me... sometime.. I enter value in a ... let's say date field ! and when I refresh my form... the date I entered is no longer there... it doesn't record the date... any idea ?

[ajetrumpet]

most likely you're query cannot be updated. see here for reasons why: http://allenbrowne.com/ser-61.html

[NTC]

If you are actually entering the data (as opposed to attempting to - but it won't let you change anything) - then there are 2 overall issues possible:

1. the data is going in - but the cross referencing field is not - so that when you call up that query again the record is not showing. if this is the case you should be able to look thru this one table itself and find these 'orphan' records. The fix is to be sure to have the cross referencing field also get entered into the record.

2. your form/record is 'dirty' - this is a term you can look up. it means you are in write mode, there will be a pencil icon to the left of the record when you are in the form. you are leaving the record while in write mode so that it doesn't consider the record completed and does not write the change to the table. the quick and dirty test is to tab thru the entire record or otherwise move focus outside the record to assure the write is done...and see if that works. you can force the write with a me.dirty=false at an appropriate user event or when the form closes or something if this is the issue....

Hope this helps.