Form based on a query

[jbs]

Hi All,

I have a database that contains many tables linked via relationships and the relevant infomation has been extracted via a query.

I now need to create a form that will display the infomation from the infomation in the query, but i seem to be having a major problem.

1. When I create a form, multiple identical forms are created and to see the other infomation from the query i need to press next in the tool bar at the bottom of the form. I need to be able to enter infomation such as Client name or Client ID and the form will then populate the other fields with the corrosponding infomation to each client name or ID.

Is there anyway of doing this?

Thanks.

 

[Peter Reid]

You'll need to add code to the AfterUpdate event to the controls used to capture the Client Name and/or Client ID info to 'find' the appropriate info (or 'refresh' the form depending on how you've designed it)

Alternatively, try adding a Combo Box to the form and use the wizard to 'Find a record on my form based on the value I selected in my combo box' which will create the code (or macro depending on your version of Access) for you. You can always convert the combo back to a text field if that's your choice

 

[jbs]

You'll need to add code to the AfterUpdate event to the controls used to capture the Client Name and/or Client ID info to 'find' the appropriate info (or 'refresh' the form depending on how you've designed it)

Alternatively, try adding a Combo Box to the form and use the wizard to 'Find a record on my form based on the value I selected in my combo box' which will create the code (or macro depending on your version of Access) for you. You can always convert the combo back to a text field if that's your choice

Thanks Peter, i added some code to a combo box and it seems to update all the text fields i need once name is selected. A follow up question.... Is it possible to check the check boxes that relate to each person? The check box is checked on the table but I'm after a way to display this on the form.

 

[Peter Reid]

Sorry but I don't really understand what you mean by your follow up question.

Check boxes can be added to the form and updated like 'text fields'