Search results

There is. Also the linked field in the sub table is a lookup field to the primary key in the main table.

One of my tables in a ‘one to many relationship’ has stopped allowing me to add new records. I've just figured out I can add records by selecting sub-data sheet on the menu bar when I've got the main table open (the one on the ‘one’ side of the relationship) and ‘expand all’. I am then able to...

BUT NUTS... It works!!! Just got home and whatever happened (went wrong basically) when I tried it this morning - didn't happen tonight!! How come it looks so flippin fantastically logical when it's right? It's maddening! Thanks again Gina.

No kiddin (that's US?)/ OMG (polite version) or Ooops.. Named and shamed! BUT...... (sorry - there is still a problem but have just had to leave for work - UK time. Will post further tonight) Thanks again.

OMG!! Didn't think you used that expression in the US - thought it was a typical british thing (Essex thing) !! Anyway - felt really stupid when I read your post - how could I miss this?? However, tried to replicate the Print Preview view but couldn't!! Changed the default view to Print...

Gina, Sorry for the delay! DB as attached.

Gina, Thanks. Checking the database again today I noticed two essential lines of code missing ........ Option Compare Database Option Explicit I got home - and I added these - but it still didn't work! In answer to the questions you asked - 1. I created a group footer in the report for...

Thanks but still nothing@!? Looking at your code it did dawn on me perhaps I should have placed my sub report in the group footer which I have now moved but I still can’t get any code to trigger on any event. I looked at “Tools/ References” in the VBA window to make sure I had ticked all the...

Why is it so difficult to hide a sub report in a report when it has no data? I have seen a number of replies to simillar questions in this forum and they are all different and in my eyes don't have enough information to allow them to work. The nearest to a completion answer I have seen so far is...

that's soo wrong!!

Sean, Brilliant - have never had a more constructive response in all the time I've posted on a forum. All the code, examples, tutorials - fantastic. All I need now is an hour or so to carry it over or translate it into the database I am using. Can't thank you enough. Thanks Sean. Jim

I think this is probably a waste of time anyway because as I understand it all the data for each of the controls on a subform is loaded even before the data for the main form but here goes anyway. I have four tables - 1 is a list of users, 2 a list of manufacturers and 3 a list of products the...