Creating a subform - you cannot add or change a record because a related field...

[dwheatley]

Hi all,



I have a form which I use to save new data to a table.

Within that form I want a subform which allows my colleagues to quickly view the information they have entered previously, and edit that information if necessary. The tables are all in a back-end database and I'd like to utilise the subform so that it is easy for them to check back that they have correctly entered their data.

I haven't used subforms before. On my form I created one from the controls in the design tab. At this point I am guessing: for where I want the data for the subform to come from, I chose 'Use existing tables and queries' and selected the table which the main form saves data to.

'Would you like to define which fields link your main form to this subform yourself, or choose from the list below?' - any guidance here? I have tried a few different options, including 'none', and keep getting two errors from access related to one of my fields (pictured here).

Sorry for the long-winded explanation. I'd really appreciate any advice as to how best to implement what I'm trying to do.

Thanks!

[ranman256]

the subtable MUST have the same key field in tService as in the master table,tCompany:

ex: tCompany table:
CoID (autnum)
CoName (text)

tService table:
CoID (long)
ServiceID (autonum)
ServiceDate
etc

here CoID exists in both AND in the relationships, you must join CoID and set it ENFORCE REFERENTIAL ENTEGRITY. (and the Cascades)
Then you can have 1 Company to Many services.

[Missinglinq]

...I chose 'Use existing tables and queries' and selected the table which the main form saves data to.

This sounds like you're using the same Record Source for both Main Form and the Subform...is that the case?

Linq ;0)>