Dynaset requery single record

[Frank_B]

Hi all,

I've got a problem with requerying a single record in a dynaset formtype.

Currently I'm tasked with rebuilding the find database for an archaeological project. The project leader wants to work in a "table-like" form so I have to work with a dynaset form (or continuous form I believe you can call it too?).

Anyway, in the form there are two comboboxes, 'material' and 'category'. When a material type has been selected, the category combobox will requery based on that answer. So if one chooses ceramics, only categories that are ceramics can be selected from the category box.

I use the requery function in the material afterupdate to reset the category box for every new record (the material field must always be filled in first).

The problem I have is that when someone wants to change a previous category entree, the query is set for the last selected material group. So if you last created a record with the material type "glass" and you want to change a previous record that has the material "ceramics", only glass categories can be selected. This can only be solved to reselect the material type of that record.

My question: is it possible to requery the category combobox based on the material combobox of the same record even if you want to 'update' a previous record?

I hope I made myself clear. If not, let me know!

Frank

[June7]

The combobox requery will use the material value of the current record, that is whatever record has focus. Can put the requery code in the category combobox GotFocus event.

[Frank_B]

Thank you! It works now.