Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

linking controls in form

Status
Not open for further replies.
becshu

becshu

Technical User
Jan 28, 2003
18
US
Hi,
I have a multi-page form that links several tables. The tables are related by an ID number. One the first page of my form, the ID number is auto-entered for the first table, then when data is added to each additional page/table the ID number is automatically updated to what it is on the first page. However, if I don't add data to a certain page, the ID number for that table does not get added and when I try to add data later for that table (through the form) I get an error. I thought I could get around this by automatically entering the ID number for every page once the ID number has been entered on the first page but am not having any luck making this work. Does anyone have any ideas?? I tried using some "before_update" commands, and other things like that, but nothing seems to be working. Help!!
 
Sort by date Sort by votes
When you say the tables are related by ID number, did you use the Relationships tool to formalize the relationships?
 
Upvote 0 Downvote
Yes, they are related in the relationships table as well as using the initial table's id as a control source for the other tables' ids.
 
Upvote 0 Downvote
Did you try turn on referential integrity and cascading updates for your tables ?
 
Upvote 0 Downvote
I tried enforcing referential integrity and it seems to work occassionally but not always. I keep getting an error that I can't add to a second table because the first table doesn't include a comparable value in the related field, but that's not the case. I'm completely baffled. I think one way around this problem would be to automatically enter the ID value of the first table into all consecutive tables (which are all included on this one form) but I'm not succeeding in doing this. I'm used to working with forms and VB in excel where this would be very simple, but I can't figure it out here. Any tips would be appreciated! Thanks.
 
Upvote 0 Downvote
You would have to code it in ADO. Any experience there?
 
Upvote 0 Downvote
Nope. Not that I know of.:) I have lots of experience using VB, macros, and forms with Excel, but this is my first real project in Access. Is ADO something that is often useful when programming Access projects? If so, is there a book or site you would recommend where I can pick up the basics? If not, I'll try to find another way to go about my project. Thanks!
 
Upvote 0 Downvote
I've decided to give subforms a try. I think this will fix my problem. Thanks for your help!
 
Upvote 0 Downvote
Sorry, thought you were using subforms. They should work fine.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Zyborg
  • Locked
  • Question
Using a variable as reference to a form
Replies
5
Views
449
Zyborg
Zyborg
V
  • Locked
  • Helpful tip
Capture Shift Key if Pressed on A form
Replies
3
Views
440
strongm
strongm
JimStrand
  • Locked
  • Question
Trying to Use Form Control as Variable in Report Control Source 2
Replies
5
Views
482
Andrzejek
Andrzejek
JimStrand
  • Locked
  • Question
Using Report Header (Form control) as Variable in Report Expression 1
Replies
11
Views
1K
dhookom
dhookom
Moss100
  • Locked
  • Question
Stop user changing size of Access Application (not form)
Replies
1
Views
553
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top