Strange form & subform behavior

[PaulA]

Hi, all -

I recently revised an A2003 database to 2010 and am now using the navigation type of form. In two of the second level tabs in the navigation form, I am getting strange form/subform behavior.

1. The first tab opens blank; no form shows at all. If I move to the last tab then back again, it appears, but not until I've moved to the other tab first.

2. Most but all of my subforms are blank, and it, again, seems to be based on the tab. The form mentioned in number 1 above, when it does appear, has blank subforms and the subforms in the second tab which seemed to be OK yesterday, are now also blank.

Things like Data Entry property on these forms are set to NO and the queries behind these forms/subforms are all updatable.

I've tried recreating the subforms and/or reestablishing the links (a PtID field) and it doesn't do the trick.

This seems like rudimentary stuff so any help of thoughts would be appreciated!!

Thanks.

 

[sneuberg]

I moved a small system to navigation forms once and found it a nasty experience, mainly because all the forms end up subforms of the navigation forms. So all the references, like Forms!SomeForm!SomeControl have to be redone. So if your forms have record sources with references to form controls you have your work cut out for you. Good new is you will become an expert on this. Here some links I used for figuring them out.

http://access.mvps.org/access/forms/frm0031.htm

http://ss64.com/access/syntax-references.html

 

[PaulA]

Thanks for your response. What's strange is that they seemed to function, or that the functioning is inconsistant.

I understand about the references as I've gone through most of that already and thought it was done correctly.

One added issue was that in doing this I had to change an initial primary field in a primary table from a text identifier to an autonumber (retaining the text field as a separate field) so much of the database configuration and table relationships needed to be redone - but, again, it seemed to be fine, but now I'm getting these issues.

I'll check out your links.

 

[Alvarogue]

have you copy/ pasted in the navigation form? I found it troublesome sometimes cause they were not attaching to the form itself but just hanging in mid air lol