Search results

Sorry I don't know what this means "extraneous table in the Recordsource"?

Hi Pat, thanks for this......I'm completely lost now......I'm happy to make the changes but if you can explain what I need to do then I'll be able to follow it through and hopefully better understand....thank you in advance

Attached is sample DB of the issues I'm having now, it is almost working! 🤪

HI All, thanks for all the help, much appreciated. Am making progress!! Three things..... 1. Modify the Master/child links to fix the name of the child link to be just POID - I'm assuming you mean delete the relationship in the relationship window then remake that link? It was just POID in...

Hi Pat, Thanks, I've stripped it right back, there are a few fields in the tables that are/were linked to other tables, anyway the fault is still there when you open frmPO, enter the details is fine, but then when you try to add a line item the error comes up

I'm guessing it's an easy thing to do when your an expert on access :D

Subform not syncing correctly, get the same error. I setup the subform as discussed earlier in this thread

I setup the links in the relationship window after making the tables, as far as I know subform controls are set correctly...I removed the default value and it didn't like it 🤪

No macros being used, I have the default value of a text box as =[Forms]![frmPO]![POID] so that frmPODetails has a reference back to the correct PO number

The master/child links work, everything works fine....except this error message, as there is no code it doesn't make sense to have it

I do not have any code

I have a query as the source

There is no indexed property showing on the property sheet?

As far as I'm aware access has not updated since last Sept, everything else is working fine

Yes it is setup like above with Unique records set to yes....it was No but changing it has not altered the error message

Is there some vba I can put 'on entry' for a new record that will suppress this error message? It doesn't seem to effect the working

I click on OK then it works as it should

This is what I've done, still appearing?

Its a split DB that's quite big with lots of relationships, would be a big file and awkward to do?