Search results for query: *

I suspect that your form is re-querying as you leave the edited field, You are displaying concatenated fields (within the query - from the table), but also displaying each individual field - which are both editable. Can't you leave out the concatenated field in the query, and simply set an...

And the reason for that, is that rs is simply pointing to a recordset object - it has no idea how many records that recordset has until you move it to the last record. If you used .movefirst instead of .movelast - it would return 1. ;-) Def Give a man a block of code, and he'll solve one...

You mention that you have ONE sub-form, but TWO sub-tables. Are both on the same sub-form? If so, what is the sub-form container parent / child relationship? If you expect individual behaviour for each sub-table, I'd expect 2 sub-forms - one for each table. I'm also intrigued about it behaving...

I don't understand why you are delaying data updates until another form is opened. Why not update records immediately as they are required, THEN allow a form that is being opened to simply display those changes? Execute a data update using "currentdb.execute (updatequery)" exactly when it needs...

integrity: I think that you may have fallen into the trap that I did (years ago). Your sub-form does not sit DIRECTLY on your parent form, it is sat within a 'container' that holds your sub-form. So, when you state: Forms![Form2]![Form_Recipes-new].Form.cRating, 'Form_Recipes-new' IS NOT...

Maybe I'm missing something obvious, but you seem to expect the underlying table (that stores a checkbox value) to immediately reflect a change on the form, and then basing logic on 'reflected' changes in tables. Is that correct? If so, then, it doesn't work that way; it's not like typing a...