Data Entry Issues With Form and Bound Fields (tabs)...

[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.

 

[ABAX via AccessMonster.com]

I am aware that you wrote that you don't have code but have you set the
Form_Timer Event (running a Macro) anywhere in your database?

Hey everyone,

[quoted text clipped - 33 lines]

and
the one that was just created works no longer.

Van - thanks for responding. I have gone over the entire db and there is
nothing that is on timer. I would be willing to shoot you the db so you
could see it. Honestly - I have never seen anything like this. It's in A2K3
but would convert to lower versions. Thanks again for you help.

 

[Van T. Dinh]

Repair & Compact the DB then zip it then send to:

vanthiendinhATaccessmvp.com

Can't promise I will have time to look at the database quickly though ...

--
HTH
Van T. Dinh
MVP (Access)

I am aware that you wrote that you don't have code but have you set the
Form_Timer Event (running a Macro) anywhere in your database?

Hey everyone,

[quoted text clipped - 33 lines]

and
the one that was just created works no longer.

Van - thanks for responding. I have gone over the entire db and there is
nothing that is on timer. I would be willing to shoot you the db so you
could see it. Honestly - I have never seen anything like this. It's in
A2K3
but would convert to lower versions. Thanks again for you help.

 

[Van T. Dinh]

You may want to check Allen Browne's article:

http://www.allenbrowne.com/ser-46.html

also.