I feel like a total idiot. I thought this would be really easy, but I can not do it!!!
I have a table 'products' with my 'product id', descriptions etc. a lot of fields are in this table. every product has a unique product id.
I want to make a form, where the user can select the product id from a dropdown box and modify some of the fields associated with that product. They can not add or delete products, only modify some of fields.
I made a query to select the product id and some other fields from the products table. The query works fine.
The I made a from that is bound to the query. The form has a header with dropdown box to select the product id. The form has a detail section with some additional fields bound to the query.
The dropdown box works fine, but here is the problem: I thought that once the user selected a product id from the dropdown box, it would automatically populate the fields in the detail section with data from the query. It does not do this. The data in the detail section does not populate correctly. It populates with the data from the first entry in the query and when I select a different product id from the query, the data does not change.
What am I missing???
As always thanks for all your help in advance.
Sarah
Posted by: sarahk@schemesoftware.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar