I saw Jon Vinson's answer only after I posted my last response and I thought
it correctly diagnosed the problem. I guess I'm not sure what you're trying
to solve now and how I can help. Is your set-up working now?
Nesting subforms just means that there is a subform within a subform within a
main form. This is used where there are three levels of data; I wasn't sure
whether this was what you meant when you said you added another subform.
However, if both subforms are directly related to the main form, there is no
need to use nested subforms.
As far as adding a button to move to a new record, where are you trying to do
this? Let's use a convention like this: you have 3 forms - FormA, FormB,
FormC; if FormB is a subform of FormA, call the combination FormA(B); if
FormB and FormC are subforms of FormA, call the combination FormA(BC); if
Form C is a subform of FormB and this combination is a subform of Form A,
call this FormA(B(C)). Creating a button to move to a new record within the
same form should be fairly straightforward. In fact, you should be able to
use the Access button wizard to do this. Are you trying to move to a new
record in a subform? In general, I try not to duplicate built-in functions;
in this case, the built-in record navigation buttons allow users to move to a
new record. I feel that users should know how to perform rudimentary tasks
and have a basic understanding of Access (just like Excel or Word).
Otherwise, it's just too much hand-holding and unnecessary programming.
Dos said:
I followed your advice earlier. I opened the main form
(Subscriber/Company Data Edit Form) and dragged both sub forms onto it.
I then went to the properties field of both sub forms and used the
childlink to link the SubID on both subforms to the SubID on the master
form. This worked and went fine until I started trying to make a
button which would allow me to edit another record after I finished the
one I was on.
Would it help to have them nested? If so, what do I need to do? I'm
willing to try just about anything to improve this thing, I'd send it
to you if you wanted to see it...
I've been playing with access for several years, but never needed
anything this indepth. Now I'm learning lots and getting better, but
still don't know enough to ask the right questions. I have a couple of
books that I think have some of the information I need, but don't know
how to find it in them... not really ready to sit down and read 1200
pages just to find that one nugget that helps right now, and I do look
through them before I post just to see if it's an obvious answer.
Thanks for all your help,
Byron
Do you have a nested subform or just two subforms in one main form? The
error seems to indicate that you've selected a button rather than a field to
[quoted text clipped - 26 lines]
Message posted via AccessMonster.com