Parts Form

[cmfog]

Is there a way to create a form and inside the form you fill out company information in text boxes and then farther down the page there is a list of parts that you can choose from and then be able to check which parts you wants. Then be able to go back and add or remove parts you don't want?

 

[GinaWhipp]

The simple answer is yes, however, it comes with a but...

You would need to create a Form for the Company Information and then a Subform for the Parts that belong to that Company. In the Subform you can add/delete/edit all the parts you want. The same goes for the Main form where you can add/delete/edit all you want.

However, your first step would be to create the Tables. Have you done so already? Or is that the part you are looking for help on?

 

[CJ_London]

yes - have a main form for your company information and on the main form put a subform for the parts.Your question is very general so for more detailed assistance please be more specific about what you want to be able to do

 

[cmfog]

Ok I did the company information on a form page but when I click to the next page on the form the check marks remain on the parts subform

 

[GinaWhipp]

Not sure what Check Marks you are talking about but have you *linked* the Main form and the Subform? You need to do so so the *move together*.

 

[cmfog]

I have made a field in the table "parts" that is a yes/no check box. I did this so that I can check/uncheck the parts I want in the subform. As for linking do you mean build a relationship? because I have tried that but it isn't working

 

[GinaWhipp]

If you are using the Check Box as a toggle then you need to add that to the Record Source so it knows which ones to not show. What is the Record Source of your Subform?

As for linking no not Relationships, you need to link the forms...

Link Master Fields
Link Child Fields

So that the Parts showing in the SUbform are the Oarts that go with that Company.

Now, when you say the Relationshios aren't working, what exactly does that mean? If you have not established Relationships because it won't let you then there is another problem that needs to be dealt with ASAP. Can you upload your database? We need to see what is causing that... (Note: You can empty it, we don't need the data.)

 

[cmfog]

The record source is the table of parts. I shouldn't have used the word relationship that was the wrong term. But has for linking. How am I supposed to link the forms when I choose to link it tells me to choose fields so I tried linking the ID field from the parts and the ID field from the company but then it made my parts subform blank

 

[GinaWhipp]

Okay, going to either need to see the file or you need to post the Tables involved and how they are related.