Update records in a table from a query

[KW99]

Hi,

I have created a form with drop downs to set the parameters for a specific query. I have also created a command button to run the query when the desired parameters have been chosen. The query then pops up when the run button is pressed.

Is it possible to add a button (attached to the query results) to open up the relevant record. I am trying to work it so that the user can update the relevant records from the query results. I guess to do this, I will need to have the results pop up in a sub form, rather than just popping up on the screen as is currently the case.

I am pretty new to this so excuse me if this is a stupid question.

Thanks in advance

K

 

[apr pillai]

If you are trying to edit the data by making selection on the drop-down control then you don't have to use a Query to do this. Do the following:

1. Move the Combo Box that you have created into the Header section of the Main Form.
2. Design a second Form (in tabular format) on the table that you want to edit the records.
3. Drag this Form into the Main Form's detail Section.
4. Display the Property Sheet of the Sub-Form (View- - > Properties) while the sub-form is still in selected state.
5. Set the name of the Combo Box in the Link Master Field Property.
6. Set the corresponding name of the field in the sub-form in Link Child Field property.

When you make a selection in the Combo Box its corresponding record will appear in the sub-form. You can do whatever you want to do with it.

 

[KW99]

Hi,

This works great thanks, however one quick further question.

Is it possible to use this method for seven to eight dropdowns (i.e. to filter the records like query parameters)?

Thanks

K