Re: establishing sub forms existing forms



On May 9, 6:44 am, Pixie78 <Pixi...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I'm still pretty new with all this but I would say yes. I had my forms set
up that way but then I changed my subforms to read only. But in the
beginning I did enter in my info on the subforms and it updated my tables as
it should. As long as your forms are drawn from your tables and your tables
are related correctly you should have no problems.



"Danny" wrote:
I was curious if this is possible. I have approx 4 or 5 forms that
update different tables in the database. Is it possible to establish
a sub form on these 4 or 5 forms, without having to rebuild from
scratch? The intent would be so users can enter information into
each form without having to open each form.- Hide quoted text -

- Show quoted text -
Thanks for your responses. A couple of things I was wondering.

The tables are table 1 has a one to many relationship with table 2 and
3. Table 2 has a 1 to many relationship to table 4 and 5.

Would a sub form work in this fashion or would something else be
needed to make this work?

When looking at the sub form using the wizard it shows all data fields
basically on one form in form view. Is there away to set up a sub
form that looks like a single form type in form view and to tab to the
other forms?

.



Relevant Pages

  • Re: Code to make form Read Only
    ... Locking bound controls on a form and subforms ... > Hi have a main form which contains a sub form, ... > entry person then inputs the responses to the questions. ... if the data entry person starts mucking ...
    (microsoft.public.access.modulesdaovba)
  • Re: New record at top of subform
    ... but you can simulate the effect you want by having two subforms. ... one line one at the top, with its Data Entry property set to Yes, so it only ... >>>in decending order. ... >> new record at the bottom of the sub form. ...
    (microsoft.public.access.forms)
  • RE: Changing Subform
    ... >> reminders for that preparer. ... >> on the preparer name chosen in the combo box) and hide the other 3 subforms. ... >>> sub form to the field in the main form ... >>> Good luck ...
    (microsoft.public.access.forms)
  • RE: Changing Subform
    ... In the option I gave you, you don't have to create 4 subforms on the main ... > i have a form called "preparer reminder select form" and pretty much what ... >> sub form to the field in the main form ... >>> display a certain form depending on the field that is chosen on the main ...
    (microsoft.public.access.forms)