Combo Box help

[wrens_splein]

Hi
From a previous post I have managed to get the second box (Model) display the correct list depending what was selected in the first box (Manufacturer).
The problem I am having now is when you try to select something from the Model box it always picks the first entry no matter what select.
Any ideas greatly appreciated.

Also, this is probably a simple one but when I click to create a new record the combo boxes hold the data that was in there and displays it on the next blank record. Is this something to do with refreshing the form itself?

Thanks in advance for any advice/help posted

 

[dcx693]

What is the rowsource of the second combo box? Post it here so we can take a look at it.

Not sure I understand your second problem. Can you explain more?

 

[wrens_splein]

Here is the rowsource:

SELECT MODELtbl.MANID, MODELtbl.MODEL
FROM MODELtbl INNER JOIN [MANUFACTURERtbl Query] ON MODELtbl.MODELID = [MANUFACTURERtbl Query].MODELID
WHERE (((MODELtbl.MANID)=[Combo20].[VALUE]));


The second problem I will try and explain better:

For instance if I selected "Dell" from the first Combo and then the second combo box I select "Latitude D800" those two entries would stay there on the form. So I would create a new record and on that record those two boxes would still be displaying the previous selections I had made instead of being blank and ready for a new selection. It is as though the form is not being refreshed when go to create a new record.

Not sure if that makes it any clearer.

Thanks

 

[Nenya]

I have the same problem i think...

2 combo boxes :
the second one list is depending on the first one selection

Until now, i used a request to get the right values, but when i change the selection of the first combo box, the second combo box is not updated.

Also, i tried different macros and or functions (as requery) but it doesn't work since the values cannot necessarly be saved...

Anyone knows what to do?