carlchapman
Registered User.
- Local time
- Today, 17:32
- Joined
- Jul 25, 2006
- Messages
- 29
Hello, I have a bit of a wierd one. I have a chase form, where you enter the CONTACTS detail (select name from combo, data, notes, chase). I then inserted a sub form that shows all related chases to the CONTACT ID not the CHASE ID, so i get a nice list of all previous confos when typing in the new data.
Here is my problem. If you just select the CONTACTS name, it brings up the list of related records. Because some Contacts have had many chases, their is a big list, and i need to scroll the subform. if i click the subform, because i have fields in the main form that cannot be NULL, it prompts me i need to fill in all fields first. So when i click the subform, my main form is trying to save the data.
Is their a way so it only updates the data if i tell it to through a onclick, or wheneva i click a subform will this happen?
I did come up with a work around, but it doesnt gain me much. The workaroundwas to set the tab to disable data, so i can view the subform as required and not edit it. Thats fine for be, but you canot scrol!, so for this to work i would need a bit of VBA to rezize the subform, contained in a tab to accomodate all the records??
the latter, seems like a bad idea, let me know what you think.
ty
Here is my problem. If you just select the CONTACTS name, it brings up the list of related records. Because some Contacts have had many chases, their is a big list, and i need to scroll the subform. if i click the subform, because i have fields in the main form that cannot be NULL, it prompts me i need to fill in all fields first. So when i click the subform, my main form is trying to save the data.
Is their a way so it only updates the data if i tell it to through a onclick, or wheneva i click a subform will this happen?
I did come up with a work around, but it doesnt gain me much. The workaroundwas to set the tab to disable data, so i can view the subform as required and not edit it. Thats fine for be, but you canot scrol!, so for this to work i would need a bit of VBA to rezize the subform, contained in a tab to accomodate all the records??
the latter, seems like a bad idea, let me know what you think.
ty
