is there a code that forces data entry?

[simeon_rose]

hi...i have 3 tables. in each one is a field called ID - for the first table it is referred to as ID1, for the second ID2 and the third ID3 (unsurprisingly). however, is there a way to write either a bit of code or something that automatically makes ID2 and ID3 equal to whatever the autonumber generated in ID1 was? please help...you people are my lifeline...

 

[Jman]

Have you tried to set the validation rule on your tables maybe something like >=0 would work this would force some one to input either a zero or some positive real number into the field that contains this rule You can set validation rules for a table in the tables design view you can also set validation tex Validation text would generate an error message based on the text you've entered Validation text can be set in design view of the table also This is one avenue only there are always more than one way of doing things in access Let me know what happens Email me at jkc3computerhack@yahoo.com
Thanks John C

 

[Peter_Darby]

alternativly, u can try this,
for the id2 field, select the datatype as lookupwizard make sure "i will select values from table" is checked then click next, then select the table that id1 is in, then select the field id1

this won't automatically enter the value for you, but it will however present you with a dropdown menu when selecting the value for id2 with only options from id1, you can type in another number however most people would just select from the list

hope this helps,
Peter

 

[Richie]

If your tables forms/ subforms are linked correctly the ID fields will update automatically when adding new records.