Field not saving

[Gavx]

I have a database a friend started for me which I am working through trying to understand.

On a form there is a sub form.

On the form I can only cycle through the records that have been created since the last time the form was opened. I cannot cycle through all records. Is this normal for a form. I assume some code might change this behavior.

More importantly when I look at the sub form in datasheet view I notice the first field of each record is not displayed (saved?) unless it is the very last record created. (This field has a SQL statement as a row source). Is this normal - or are the last 2 paragraphs descriptions of the same thing?

thanks

 

[essaytee]

I have a database a friend started for me which I am working through trying to understand.

On a form there is a sub form.

On the form I can only cycle through the records that have been created since the last time the form was opened. I cannot cycle through all records. Is this normal for a form. I assume some code might change this behavior.

More importantly when I look at the sub form in datasheet view I notice the first field of each record is not displayed (saved?) unless it is the very last record created. (This field has a SQL statement as a row source). Is this normal - or are the last 2 paragraphs descriptions of the same thing?

thanks

First step is to check the Recordsource of your form. Check if a WHERE clause is present, if there is, it maybe the culprit. Also check your form for the Filter property, this maybe set.

Not sure about your sub-form issue.

 

[Gavx]

Yep, that form is subject to a filter;
[ParticularRecord]=1

I suppose I can start by deleting this and see what happens...