Parameter Query and forms

[Guest]

Can any one help? I'm no access expert but do understand the basics.

I've got an exsisting DB with a complex form. I've created a parameter Query
that uses a combo box, this query is controled from a form. So I select a
country press OK and all the data for that country is shown in a table. This
all works OK.

I want to be able to display that data in my exsisting Form or at least a
direct copy of that form, once the data is displayed in that form I want
users to be able write data into it so that the main table is updated.

Any simple way of doing this?

 

[Guest]

Can any one help? I'm no access expert but do understand the basics.

I've got an exsisting DB with a complex form. I've created a parameter Query
that uses a combo box, this query is controled from a form. So I select a
country press OK and all the data for that country is shown in a table. This
all works OK.

I want to be able to display that data in my exsisting Form or at least a
direct copy of that form, once the data is displayed in that form I want
users to be able write data into it so that the main table is updated.

Any simple way of doing this?

If I understand the question, this will probably work:
1. Setup a form to work as if you were just providing a form to handle the
underlying table in it's entirety for the fields you wish to update.
2. Add a combo box to the form, populated from the list of countries.
3. Add to the combo box after update event, the apply filter action, where the
criteria is that the Country in the underlying table is equal to the Country in
the combo box.

gm

 

[Guest]

Thanks for this I think this will work, my VB code knowledge is not very good
though, what would the code have to look like, in the "after update event"?