Hi,
I volunteer for a charity that supports people with disability ('clients') and I'm trying to create a database for the organisation.
I have two tables, 'Client Details' (Name, address, date of birth, cultural background, type of disability, phone number, etc) and 'Client Issues' (Client name, date of issue, issue details text, - and they also want to record the cultural background and type of disability here too.)
I created a query based on 'Client Details' table that returns three columns: Client name, Cultural Background, Type of Disability.
In a 'Client Issues' form, I have created a combo box called 'Client Name' that looks to the first column of the above query and allows a user to select a client name - it is called Combo125. I then created two text boxes and in the control source for each I entered =Combo125.column(X) where X= either column 1 or column 2 of the query, to return the cultural background & type of disability data I want to match to the client's name.
So far, so good. However, in the form, when a user selects a client's name, the cultural background & type of disability text boxes update correctly, but I would like the data that appears in these two text boxes to be inserted into the corresponding field in the 'Client Issues' table. This is because the charity would like to report on how many issues occurred according to the cultural background & type of disability of their clients. This is not currently possible as the data, when it is auto-updated in a text box, does not get updated in the table.
Thank you very much for any help you can provide!
Steve
I volunteer for a charity that supports people with disability ('clients') and I'm trying to create a database for the organisation.
I have two tables, 'Client Details' (Name, address, date of birth, cultural background, type of disability, phone number, etc) and 'Client Issues' (Client name, date of issue, issue details text, - and they also want to record the cultural background and type of disability here too.)
I created a query based on 'Client Details' table that returns three columns: Client name, Cultural Background, Type of Disability.
In a 'Client Issues' form, I have created a combo box called 'Client Name' that looks to the first column of the above query and allows a user to select a client name - it is called Combo125. I then created two text boxes and in the control source for each I entered =Combo125.column(X) where X= either column 1 or column 2 of the query, to return the cultural background & type of disability data I want to match to the client's name.
So far, so good. However, in the form, when a user selects a client's name, the cultural background & type of disability text boxes update correctly, but I would like the data that appears in these two text boxes to be inserted into the corresponding field in the 'Client Issues' table. This is because the charity would like to report on how many issues occurred according to the cultural background & type of disability of their clients. This is not currently possible as the data, when it is auto-updated in a text box, does not get updated in the table.
Thank you very much for any help you can provide!
Steve
