Multiple input boxes on one Form only show connected fields

[ElcoyotldeAztlan]

Hello Everyone,

I'm creating a form base off of 10 Tables, The person I'm designing this for, Wants parts of the fields (or input boxes) of each table on one form. I had no problem creating a blank form and inserting the desired boxes and connecting them on the form, however the data that is shown is only the data that is the data that is connected in all the boxes, for example If I had 3000 cars and I only had 100 filled out with the color of that car. The form only shows 100 records when I have the Car box and color box on the same form. My question is why can't I go to car 101 and the color box can be blank and I can fill in the color there on the form view?

any suggestions?
Thanks

 

[static]

So, the car table is connected to the colour table in the query.

In the query design view, double click the connector line and select 'include all records from cars...'

All cars will be listed even if they have no colour record.

For the colour to be updateable via the query you need to create a relationship (database tools/relationships) between the two tables in a similar manner.

 

[ElcoyotldeAztlan]

I have them connected by relationships is a query connection essential ?

 

[static]

How have you connected the the tables if not via a query?

If you have created suitable relationships, they should flow through to the query automatically.

 

[ElcoyotldeAztlan]

I connected only by Relationship, would that mean I would have to create a query

 

[ElcoyotldeAztlan]

I just connected in the Query view, ALL the car records shown and just the color records connected option and it doesnt seem that it work Do I have to run the query?

 

[static]

Creating a query is the normal way of doing things in Access.

It's not essential that you create a query, But since you are here asking these questions I would recommend that you do.

 

[static]

Upload a copy of your database

 

[ElcoyotldeAztlan]

Thanks I got it to work after I changed it in the Join Type in the Relationship view section. Now the funny part is that the sections that are connected (cars that have colors) are at the end of the records it's no longer Car 1 Car 2 Car 3...because they are connected with color, it starts with Car 7 (which doesnt have any color selected. Any idea how to fix that? To make the records say
Car 1 Color Red
Car 2 Color Blue
.......
Car 6 Color Red
Car 7 Color (NEW)

Thanks

 

[static]

Set the sort criteria in the query design grid.