Search results

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.

I think the Subform is a red herring and is not the issue. Also, I will be using a combination of text boxes, combo boxes, etc as filters. So this is also something that we should not get hung up on. The purpose of the subform is to display records in a datasheet format. It is not possible...

Still no luck getting this to work with your code and my design, so just summarising where we are with this so that anyone else can offer their thoughts: So far it appears that you are not able to turn off data entry on a subform before using a requery command to refresh the data based on an...

The Reference field is a text box by default. Are you refrring to the format of the number within the field or comparing it with the combo box you had in your version? I'm not intending on using a combo box due to the number of potential records. Similar to the data entry approach - I'm...

Many thanks Mr B. Looks like you have done quite a bit with it. The subform is used as a datasheet and is not actually a tabular form or similar. However, your comments are very interesting and I will look into that a bit, as I spent some time deciding on using a subform. The first thing I...

Here's the database. Though i have had to strip most of it out, the code that is left is all there is for these forms. Thanks.