A
ABAX via AccessMonster.com
Hey everyone,
I am about to go crazy. I am setting up a CRM system and thought it was a
pretty cut and dry project. Here is the db layout. I have set up
relationships between a master client table and several detail tables
(invoices, contacts, communications, etc.). I have a form that has about 8
tabs with the details broken out on each. 5 of the tabs have one subform on
each, while the remaining 3 have two subforms all of which are bound directly
to tables. Subform A is a datasheet while Subform B is simple form which
lists further details from A. When users click on a row in A it displays
details in B. It does so by using a hidden text box with A's rowsource ID
field. Then B looks at it for it's master.
Hopefully that makes a little sense....
Anyway - the issue now is that it works great until you try to update fields
in B and then it goes haywire. If you don't type fast enough the field
highlights and you wind up typing over what you've entered. Additionally, if
you just leave the cursor somewhere over the subform it's blinking back and
forth between the hour glass and the cursor. I mean I haven't created any VB
procedures other than some defaults that Access created.
Seriously - your ideas would be so appreciated.
- Aaron
P.S. If I delete the tab and recreate it the problem does not replicate on
the new tab until an additional tab is created. Then the new one works and
the one that was just created works no longer.
I am about to go crazy. I am setting up a CRM system and thought it was a
pretty cut and dry project. Here is the db layout. I have set up
relationships between a master client table and several detail tables
(invoices, contacts, communications, etc.). I have a form that has about 8
tabs with the details broken out on each. 5 of the tabs have one subform on
each, while the remaining 3 have two subforms all of which are bound directly
to tables. Subform A is a datasheet while Subform B is simple form which
lists further details from A. When users click on a row in A it displays
details in B. It does so by using a hidden text box with A's rowsource ID
field. Then B looks at it for it's master.
Hopefully that makes a little sense....
Anyway - the issue now is that it works great until you try to update fields
in B and then it goes haywire. If you don't type fast enough the field
highlights and you wind up typing over what you've entered. Additionally, if
you just leave the cursor somewhere over the subform it's blinking back and
forth between the hour glass and the cursor. I mean I haven't created any VB
procedures other than some defaults that Access created.
Seriously - your ideas would be so appreciated.
- Aaron
P.S. If I delete the tab and recreate it the problem does not replicate on
the new tab until an additional tab is created. Then the new one works and
the one that was just created works no longer.