Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

SUBFORM was working and now it's not

  
   Windows Help (Home) -> Microsoft Access RSS
Next:  Accidental Duplicate Messages  
Author Message
kealaz

External


Since: Feb 4, 2009
Posts: 15



(Msg. 1) Posted: Tue Jan 12, 2010 12:39 am
Post subject: SUBFORM was working and now it's not
Archived from groups: microsoft>public>access (more info?)
Hi,

My subform (order details) in a purchase order has been working and now is
not. I have not made any changes to either form or subform... so I'm baffled
as to why it would suddenly stop working.

What it is doing (or more accurately not doing): When I'm using the form
and entering information, it does not allow me to tab into the subform if
I've entered data on the form. It does allow me to click directly into the
subform if I do not enter data into the main form first... but that only
gives me other error messages because there needs to info in the main form
first.

This was working fine, as far as I can tell, on 12/18. I have tried to
start troubleshooting this and have copied the form and subform from a
previous backed up version prior to 12/18 when I KNOW it was working
properly. The problem is still there and is the same.

I have no clue what could be the problem. Please HELP. Any advice and
guidance would be GREATLY appreciated!!!

 >> Stay informed about: SUBFORM was working and now it's not 
Back to top
Login to vote
MikeJohnB

External


Since: Nov 26, 2008
Posts: 11



(Msg. 2) Posted: Tue Jan 12, 2010 5:48 am
Post subject: RE: SUBFORM was working and now it's not
Archived from groups: per prev. post (more info?)
Just a thought

With your main form in design view, right click and select TAB Order

Is your subform in the list and is it in the right position for skipping to
the subform?????

Hope this helps

 >> Stay informed about: SUBFORM was working and now it's not 
Back to top
Login to vote
Mrs. Ugh

External


Since: Feb 9, 2009
Posts: 2



(Msg. 3) Posted: Tue Jan 12, 2010 8:30 am
Post subject: RE: SUBFORM was working and now it's not
Archived from groups: per prev. post (more info?)
Kealaz-
It sounds to me like the relationship between your tables changed. When you
try to enter the subform (after entering data into the main form), is there a
message displayed (usually very quickly) in the lower left corner of the
window? What does it say? Have you tried to edit the subform data via a query
containing the same data as the form/subform? I usually encounter this type
of problem when I have changed something in the tables that then makes the
subform data not updateable.
Jill

"kealaz" wrote:

> Hi,
>
> My subform (order details) in a purchase order has been working and now is
> not. I have not made any changes to either form or subform... so I'm baffled
> as to why it would suddenly stop working.
>
> What it is doing (or more accurately not doing): When I'm using the form
> and entering information, it does not allow me to tab into the subform if
> I've entered data on the form. It does allow me to click directly into the
> subform if I do not enter data into the main form first... but that only
> gives me other error messages because there needs to info in the main form
> first.
>
> This was working fine, as far as I can tell, on 12/18. I have tried to
> start troubleshooting this and have copied the form and subform from a
> previous backed up version prior to 12/18 when I KNOW it was working
> properly. The problem is still there and is the same.
>
> I have no clue what could be the problem. Please HELP. Any advice and
> guidance would be GREATLY appreciated!!!
 >> Stay informed about: SUBFORM was working and now it's not 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Subform not allowing update - Hi, I'm sure there is a simple answer to this, but for some reason my subform isn't allowing me to add records and I'm not sure why. I've gone through this set up a few times and I have previously been able to add records. Is there a common pitfall..

Entering records on a subform - I have read topics related to my problem but I can't seem to find a solution. I have a form that has a combo box containing events. The records for the combo box come from a query. After selecting an event, a subform is populated with staffing..

Referencing a subform control on a subreport - Hello, I would like to copy a calculated control of an unbound control on to a report. On my form (F_SampleRequest) i have a button which opens the report. Here is the code for the button: Private Sub btnOpenSampleReport_Click() DoCmd.OpenReport..

subform not opening in add mode - I can't figure out why my subform is not loading in add mode when my main form is in add mode. Both forms are based on seperate tables and the record sources have one to many relationships. My subform's Data Entry property is set to "NO". ...

Subform causing duplicate records? - I am trying to do a Purchase Order database. I need a subform in the PO Data Entry Form since there are usually multiple items in the PO. I have a command button to Print PO but I end up with a report for each item in the subform. This is the SQL...
   Windows Help (Home) -> Microsoft Access All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]