A Form crashing Access

[Lisa S]

Hi

I have 3 tables, organisations, contacts and calls. I have created a form which shows the organisations as a look-up, the contacts in datasheet view and calls in datasheet view. So I can choose an organisation to view the contacts, click a contact and then show only the calls for that contact.

I have managed to do this by creating a query that uses all of the fields I need (including all foreign keys)and using the Form Wizard to create my form. I add the organisation as a look-up (using the wizard)with a combo box. It all works perfectly when I choose an organisation for the first time but when I choose another one the whole screen flickers for a few seconds and closes me out of Access completely. I have got around 170 organisations, 1100 contacts and 68,000 calls.

If anyone can throw any light onto this I would be very grateful.

Thanks

 

[alxj]

This happens to me on a regular basis with my invoicing program all i can think is that access strugles with combo boxs.

If anyone else has any suggestions i would be interested to try them.

Alex

 

[MikeAngelastro]

Lisa,

Try using the record navigator buttons instead of the combo box for selecting the organization. See if it removes this problem and then we can go from there.

Mike

 

[Rich]

Stupid question I know but do you requery after update on the combo?

 

[Lisa S]

Hi, thanks for the responses

I have tried to use the record selectors and I can go backwards and forwards one at a time but if I click to go to the last record and then click the first record button it flickers and then crashes Access. It seems OK one at a time in any direction but backwards more than one at a time I get the problem???

I used the combo box wizard to create my lookup and this uses the requery in the code - I did wonder if this was somehow the problem but not knowing a great deal about VBA I couldn't be sure.

Thanks

Lisa

 

[Lisa S]

I think I have found the solution and thought Alex may want to try this.

After many hours of struggling I took my customer id off the main form and it works. It seems as if you take the primary key field off the main form (the primary key of the primary table)it behaves. If you needed the primary key to show you could add it as a separate sub form.

Lisa