Trying to input new records

[HJessen]

I have a large databse (MS Access 2000) that has about 10 active tables. The common thread in each table is the emply_ID. The users can look at the data in the tables via a form with 9 sub-forms accrssed via tabs.

My problem is that when we try to add a new employee data, MS Access will immediately crash upon tabbing off the emply_ID field. I know that the problem existed with the relationships I had between tables, so I removed them; however, now I can have information in two tables, but not in 7 others.

The question: Is there a way of using VBA to write the emply_ID immediately upon entering it into the field of the first form?

Thanks. H. Jessen
"Now I know more, and I feel dummer"

 

[KenReay]

Hi

You are using Subforms?

Have you set the parent\child property of the main form to Empty_id ? Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[HJessen]

KenReay,
Yes, the master-child links have been set. As I said, we did track the problem to some relationships, but without those relationships other parts do not work correctly.

Somehow, I need the hard coding to make it work.

Thanks. H. Jessen
"Now I know more, and I feel dummer"

 

[KenReay]

Hi

OK, so could you define 'crash' do you get an error message, if yes, what is it? Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[HJessen]

KenReay,

Right now I am at home (it is 5:10am here), but the message was something along the lines that windows was shutting down MS Access due to an error, and that was about all there was. I would have to wait until I get back to work to give you more details - sorry.
H. Jessen
"Now I know more, and I feel dummer"

 

[HJessen]

Found the problem!

One of my queries linked two tables. Once that link was removed, everything worked okay. Just don't know why this one linkage causes the error.

Oh well...... onward and upward!

H. Jessen
"Now I know more, and I feel dummer"