Combobox based on a query, Query based on inputs from Form HELP!!

[Stretch2312]

I am trying to create a database for managing and reporting on defect tags applied to equipment with our facility. I have set up an employee management database to manage our employees and their roles within the facilty.

I have linked this database to the "Tags" database to recored who applied the tags and who's responsibility it is to complete the tasks assigned.

In the Tags database i have 8 Tables;
Tags (Actual information relating to the Tag raised)
Actions (Actions required)
Defect (Defect categories)
FLOC (Functional locations of the machinery)
Line (Processing Line)


Machine (Machine on the line)
& Employees (Employees who raise and action tags)

Im at the stage of trying to develop a User Interface for entering Tags into the Database. Everything seems to be working, except the combo boxes based on query's.
rpeare, I had a look at the sample database you sent back. The FLOC combo box does not appear to be working in that one either.

Sorry for all the questions, I am new to Access.

[orange]

If I look at the database returned by rpeare what exactly is suppose to happen on the Tags form?
I see 2 controls with labels combo79?? What is that?
Part of your issue, in my view, is that the row source for the entered by is the Employee table which is not part of your database???
You should supply an Employee table even if you only have a few Mocked up records.

Also the row source for cboFloc
is SELECT FLOC.ID, FLOC.FLOC, FLOC.Line, FLOC.Machine FROM FLOC WHERE (((FLOC.Line)=[forms]![tags]![cboline]) AND ((FLOC.Machine)=[forms]![tags]![cbomachine]));

Floc.Line is a number but[forms]![tags]![cboline] is showing text????

You should establish relationships between your tables.

I have 2003 also, so if there is a more appropriate database to look at please tell me.

[rpeare]

I don't know what to tell you, the database I returned to you functions. If you put in a value in the first two files (the ones in that I replaced in the upper left corner of the form) the third combo box returns values that match what you were looking for.

Using the exact database I sent you if I select FC01 from the first combobox labeled combo76 and select CODER from the second combobox labeled76 in the when I click in the FLOC field I get three results

FC01-COD
FC01-COD-BARCODE SCANNER
FC01-COD-VIDEOJET

There are only 3 items in your FLOC table that match these two critera and they are the same three that are showing up in the FLOC combo box on the form. If you aren't seeing the same results I don't know what you're looking for.

[orange]

I'm seeing what rpeare is saying when I use those selections. I have 2 combo76 not 79.