A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old November 9th, 2006, 09:11 PM posted to microsoft.public.access.forms
ABAX via AccessMonster.com
external usenet poster
 
Posts: 4
Default Data Entry Issues With Form and Bound Fields (tabs)...

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.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200611/1

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:02 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.