Form Data and Query tool

[OSOK]

To say I know how to use Access is to say I know how to double-click the shortcut. I will describe what I'm doing in the hopes that it explains what I need access to do. I don't know how to formulate the question in a manner that allows me to search...which is how I've come as far as I have with the creation of a database.

I am tasked with creating a database of physical inspections that is searchable in the hopes of identifying trends by severity, location, and type. The process is to use a paper form to capture data by inspectors and have them be input into the database using a created form. Data entry I would like to keep at a minimum because I have created a table (well many tables but more on that if needed) that has the data of the buildings (multiple fields, owner, tenant, square footage, building number, etc)

I would like to figure out how to have the drop down box of the building number reference the rest of the data of table on that row and feed the database.



so on the form building 5000 is a maintenance shop 35000 sq ft owned by jimmy. I would like to select "5000" on the access form and all of the associated information feed into the database without having to select each and every data point. Because i have a list of 300 buildings and would need to "remember" who owns what where as would every building inspector. Please ask questions as I don't know how else to ask of my issue. Thank you for your time and attention and look forward to any assistance anyone can provide.

[Bkper087]

There are a couple of ways to handle this depending on what your form looks like and how creative you want to get. The basic answer is you need to create a Primary Key to Foreign Key (sometimes called parent to child) relationship between each table in your database. You can pair a subform to a main form through the properties window. I would search YouTube for examples of linking primary key and foreign key tables as well as creating sub forms that link to the primary form. Much easier to watch as a beginner.

[pbaldy]

Presuming your form is bound to a table, try using the combo box wizard to add a new combo, selecting the third option, "Find a record...".

[OSOK]

This I will look into for certain, thank you. I would now but at the workstation i'm on...i don't have speakers

[OSOK]

I've selected the combo box wizard and when asked "Which fields of tbl safety inspection contain the values you want included in your combo box? The fields you select become columns in your combo box." This is referencing the table that the form feeds...not from the table that feeds it. Currently the field i have for the drop-down list of building numbers is fed from "tbl building list" this is so no one fat-fingers the building number they are at or buildings that aren't my responsibility aren't inspected by mistake. What should be the output is being listed as the input.

[pbaldy]

Did you answer "Find a record" first? Can you attach the db here? Maybe I've misunderstood what you're trying to do.