Help! Need to Enter data!

  • Thread starter Thread starter WestWingFan
  • Start date Start date
W

WestWingFan

Ok, I have a crazy question, but surely someone has an answer. I have five
tables I would like to enter information into what looks like one form (I
know it will have a series of subforms). I can't seem to get it to work. My
tables (simplified) are: Title, Section, Item, Statement, Clarification. All
the relationships are one to many down the chain - except for the Item table
whose PK is a combo of SectionID and StatementID. It would seem to me that I
should set tblItem as the parent recordsource, but then I would need a
subform for Title (with a subform for section) and I cannot link through the
subform - or can I? I hope this is clear! Thanks in advance for any help!
 
More information. I have changed the PK to a new autonumber PK for tblItem.
This seems to help. I am still having trouble getting the sbfrmStatement to
work properly. If I link it to sbfrmItem, then I cannot add new records. If I
leave it unbound, I don't know how to write the StatementID to the correct
field in tblItem. I'm new to coding, please be kind.
 
Never mind.... it's amazing what you can do with the not in list event....
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Urgent - I'm reposting this here. Please help! 1
Clear the subform 3
MS Access 2007: Calculated field based on subform: 1
Textbox control source problem 10
Pls help with Form not able to enter data 12
newbie needs help simple form 1
Required data on subforms 2
Access won't accept records entered in my sub-form 3

Back
Top