Combo Box Auto Populate (1 Viewer)

[npierson]

How can I get a combo box to auto populate based on the information already entered into the text box/es of a form?

Thanks

 

[npierson]

Actually, I want to get a combo box to auto populate based on values entered into other combo boxes (on a form).

Thanks

 

[Anauz]

I had this problem, the way i did it was to write the sql for the combo box.

In the GotFocus() event of the "to be autoupdated combobox"

----------------------------
Dim value AS String

value = " SELECT Distinct table.[field2]" & _
" FROM table" & _
" WHERE (table.[field1] = combo1);"
-- “ AND anyother statement ;”

combo2.RowSource = value
-----------------------------

 

[npierson]

Thanks Anauz,

but I can't get it to work. Would you mind sending me sample code (just something simple)? If you will send it, please send it to dunkingman@yahoo.com. Or, I could send you what I'm working on if you would like.

Thanks again,

Nick

[This message has been edited by npierson (edited 05-17-2001).]