Form combo box with text boxes

[N3w2access]

I am struggling to work out if what I am trying to do is possible? Currently I have a form setup showing the fields(text boxes) policy, name, dates dept and a few other fields along with 25 different types of error. For each error the user will add a Comment in a text box, a comment in a text box for the response,select the date of response and a combo box to select the dept. As this takes up a lot of space on the form I was wondering if it is possible to setup a combo box for the 25 errors and a text box is populated for each error do the user can type in the comments.

Appologies if this is not very clear but any advise would be grand!


Many thanks in advance

[amrut]

If more than one type of errors are to be associated with a single record then you will need a table for the error types and a child table for the error types and the comments for a record. A combo box can be used in a sub form used for data entry in the child table. This combo box will have its row source from the table of error types.
hope above is clear to you.
See here for table relationships http://www.functionx.com/access/Lesson36.htm
See here for sub forms http://office.microsoft.com/en-001/a...010098674.aspx

[N3w2access]

If more than one type of errors are to be associated with a single record then you will need a table for the error types and a child table for the error types and the comments for a record. A combo box can be used in a sub form used for data entry in the child table. This combo box will have its row source from the table of error types.
hope above is clear to you.
See here for table relationships http://www.functionx.com/access/Lesson36.htm
See here for sub forms http://office.microsoft.com/en-001/a...010098674.aspx

Thank you for your response. Will this work the same if the tables are linked to SQL?

[amrut]

Will this work the same if the tables are linked to SQL?

I do not understand your question. Further, I have no experience with SQL server.

[N3w2access]

I do not understand your question. Further, I have no experience with SQL server.

Sorry I will try to explain more in detail. I have linked to 2 tables in SQL 1 table which has the fields: policy_ref, office, name, dept and 2 check boxes on the form and the second table has policy_ref, error type, error, comment, dept_comment, dt_of_response, class_of_error and importance_of_error. There is 25 different types of error where I am having to produce all the fields from table 2 25 times but I want to be able to put a query into each box so that the box only relates to the error type. Typically theres nomally anything from 0 - 2 errors so it would be just those error fields that would need to be recorded into the table. I know if I make a combobox I can put SQL into the Row source but I am not sure if this is the best way? Hope you can advise. Many thanks