2 data entry form in one DB

[jpl458]

The app mostly uses data that is based on one table. I need to add a second data entry form that is based on different table in the DB. Is that possible? Every time I try to create the form it uses the mater table, and I can't get it to point the the other table. Want to open the second form as a subform.

 

[theDBguy]

I don't see why not. You may have to post a sample db, so we can help you.

 

[jpl458]

I may be doing it wrong. I have the DB open and the DE screen is open which is bound to the Master table. When I go to Create Form (Form that lets you enter one record at a time) it opens based on the Master table with all the fields in tab columnar order. If I change the record source the master table fields are still there. If I create the form in design mode I can set the record source, but then have to add all the text boxes for data entry. Was hoping to save some work and not have to add all the text boxes.

 

[mike60smart]

Can you upload the database?

 

[Pat Hartman]

Access uses context to "help" us. Try closing ALL objects before you build the second form. Your problem will likely go away.

 

[Pat Hartman]

Thanks for the like @jpl458 but likes are not helpful. Did you try the suggestion? Did it work? Answers to those two questions would be very helpful

 

[jpl458]

Worked, but all the test boxes are glued together and I can't separate them. Just want a single column, not multiple rows.

Thanks for the help

 

[mike60smart]

Worked, but all the test boxes are glued together and I can't separate them. Just want a single column, not multiple rows.

Thanks for the help

If you onstruct a standard Main Form / Subform there should not be any problems.

 

[jpl458]

It is evident that I didn't understand the concept of, or how to create, a subform. I have found how to do it and if I have problems I will post, but next time I will read first.

Thanks

 

[jpl458]

Followed the steps, put main form in design view>selected subform option from controls group>clicked the location on the main form where I wanted the subform, but the subform wizard does not display. Tried several times. It creats a small formcalled CHildnnn, but no wizard. Window 10, Office 365. reread 3 different sites that say the same thing. Have no idea what I am doing wrong.

 

[jpl458]

Found the subform wizard,. But subforms are not what I need. I don't want a one to many relationship, just want to do date entry to a different tqble, so I'll just make a new form for that.

 

[Pat Hartman]

There is no such thing as a "subform" wizard. There is a form wizard. A form is a main form when you open it directly. If you want to use it as a subform, then you drag the form onto a different form. Access creates a subform control which holds the form you dragged into it. So any form is either a main form or a sub form depending on whether it is opened directly or is embedded in a control on another form.

When you use the wizards to build forms for you, you need to understand that they try to "help" you. Sometimes, that isn't what you had in mind. After you've created enough forms, you'll come to an understanding of what they do and you'll be able to make better choices in the wizards to get something closer to what you want initially. I never use forms created by the wizard as is but I frequently use the wizard to give me all the fields and then I just move them around to suit me. I always start with a query because that gives me a little better control. I can order the fields in the query in the sequence I prefer them to be added to the form. This has nothing to do with anything. It is simply one way of exerting my will on the wizard

When all the controls are stuck together, you can free them from their chains Open the form in design view and click on the Arrange tab. In the table section on the left, if those things are active, you should be able to revert them.

 

[jpl458]

There is no such thing as a "subform" wizard. There is a form wizard. A form is a main form when you open it directly. If you want to use it as a subform, then you drag the form onto a different form. Access creates a subform control which holds the form you dragged into it. So any form is either a main form or a sub form depending on whether it is opened directly or is embedded in a control on another form.

When you use the wizards to build forms for you, you need to understand that they try to "help" you. Sometimes, that isn't what you had in mind. After you've created enough forms, you'll come to an understanding of what they do and you'll be able to make better choices in the wizards to get something closer to what you want initially. I never use forms created by the wizard as is but I frequently use the wizard to give me all the fields and then I just move them around to suit me. I always start with a query because that gives me a little better control. I can order the fields in the query in the sequence I prefer them to be added to the form. This has nothing to do with anything. It is simply one way of exerting my will on the wizard

When all the controls are stuck together, you can free them from their chains Open the form in design view and click on the Arrange tab. In the table section on the left, if those things are active, you should be able to revert them.

I figured out how decouple the boxes this AM, but I really liked the way you use a query to set the order. That's handy.

Thanks

 

[Pat Hartman]

you're welcome