Recent content by tomocb

Found the problem. It is because the foreign key that I'm updating in the subform is part of a concatenated key in its foreign table. The reason it is part of concat key is because I need to make it unique against the primary key of the main form. I wasn't previously setting the foreign...

Edit - If I can ask a slightly different question then; How are others using a subform datasheet stored procedure record source?

Anyone? Or are we saying that it is actually not possible to use a multi-table select statement stored procedure as the record source for a form in Access?!?!? Surely that cannot be the case!

btw. This is not the same as the write conflict error that is a confirmed bug by MS in a subform with an identity field in underlying table. This is resolved by using a refresh command with AfterInsert and AfterUpdate. Instead this is only when I include fields from multiple tables in the...

I'm getting "multiple-step ole db operation generated errors..." in a subform which is based on a stored procedure. I have isolated the problem to the inclusion of field from a table that is a different table the one that is being updated in the select statement of the stored procedure. If I...

Mods - Please close this. Thanks for your help everyone who posted. I will post this problem on another forum.

So just to summarise for any new readers to this thread: Is it not therefore possible to use a combination of Query By Form on an unbound form and Data Entry = False property on a bound subform??? Surely this is how 'search' forms are supposed to work?!?

Just throwing this one back out there to see if anyone is any the wiser. Simon - The form that I have constructed is actually a search form and as such is read-only. Once the records have returned based on the filters selected in the unbound controls the user can then open that record in a...

I refuse to believe that there is no one who can solve this problem! Thank you to all so far who have offered alternative solutions, but please someone tell me what I'm doing wrong!

Thanks Simon MT, but that is not the issue. The issue is that I'm trying to identify why it is not possible to turn off data entry and then requery a subform based on one or more unbound fields in the main form. Unless someone can tell me that this is not possible then it is sensible for me...

Thanks Mr B. I'm not convinced that a subform has to have a parent/child link in order to work properly. I've not seen any evidence to support this. Also, it's not possible to get the datasheet format I need without the use of a subform. A form with a header/footer in datasheet format does...

Thanks Mr B. What you've done proves that it's not the subform that's the problem. But I noticed that it still uses a client-side form filter, which seems to be the only difference now between our two versions. The question remains then; Why does a subform requery not include filter...

I can access the file now, thanks.

It's the zip file that's thr problem and not the database. The zip file advises that there is nothing to extract and that it is invalid. Your working version might be cached on your computer.

Thanks Mr B, but the attachment appears to be invalid. Can you check it please.