Solved Assign Id in form based on other table

[Gaztry80]

Hi,

I have two problems which i try to fix:

First problem:
I have created a simple project form where i try to make an option to asign a person to a project by a combobox.
In addition, I want to filter the combobox with the corresponding category from the project.
My current method is that i requery the combobox when it is on current. However, my problem is that when it is requering all records, the other prefilled rows will be empty when selecting the combobox (please see attached file).

Second problem:
There could also be an option that a person is "not active" anymore, so i want that it will be not be showed in the combobox. The way i want to make this, is to put a new criteria in the recordsource of the combox (Active = True). However, when I do this, old projects will not show anymore the assigned name in the form (which is logical since the query results are not there).

Could somebody please help me dealing with these two problems?
Thank you !

 

[Pat Hartman]

Here is one way to solve the cascading combo problem. There are others.

Cascading Combos in continuous form

This is an example that shows how to work with cascading combos in a continuous form. This technique will NOT work for a form in datasheet view. Here's an update.

www.access-programmers.co.uk

 

[Gaztry80]

Here is one way to solve the cascading combo problem. There are others.

Cascading Combos in continuous form

This is an example that shows how to work with cascading combos in a continuous form. This technique will NOT work for a form in datasheet view. Here's an update.

www.access-programmers.co.uk

Thank you I had a look to your greate example files, i think i can implement this!

 

[Pat Hartman]

Great