Combo box

[nat35]

Hi there,
I have cboCompany looks upvalue were stored in a table.
Second cboSupplierName is based on the first selection
and display the names.How to open the form with one of the name of company in cboCompany.When I use onCurrent then cbosupplierName does not display any names.
thanks in advance

 

[Shortie]

Create a procedure that filters the cboSupplierName...

Sub FilterSupplierNames()
cboSupplierName.recordsource="";
if not isnull(cboCustomer) then
cboSupplierName.recordsource="Select SupplierName From Suppliers where Customer = '" & cboCustomer & "';"
end if
cboSupplierName.requery
End Sub

Sub cboSupplierName_GotFocus.....
filtersuppliernames
end sub

Sub Form_Open()
filtersuppliernames
end sub

On On
Johnathan Perry

 

[TonyJollans]

Hi nat35,

Can you not build your Supplier selection so that it is not selective when there is no company, like ..

SELECT SupplierName FROM Suppliers WHERE [Company] Like Iif(IsNull([cboCompany]),"*",[cboCompany])

Enjoy,
Tony