View Single Post
  #3  
Old March 31st, 2010, 03:05 AM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default List box populate based on combo box

On Tue, 30 Mar 2010 17:19:01 -0700, Warman
wrote:

I have a combo box that is based on a table. The three fields that are
selected should generate a listbox based on a query. The query filters the
the selection.

I can't get any info in the list box. The query works and the listbox
contains the column names but no records.

Am I not using the right fields for the query or not doing a refresh?? I am
lost - been at this for several hours - read all the posts - I know it should
be simple.

Thanks


A combo box will not "generate" a listbox. Your question is unclear; what is
the SQL view of the query? What are the RowSources of the combo and the
listbox? How are you selecting "three fields" from a combo (since a combo can
have only one value)? Do you have any VBA code or macros (e.g. requerying the
listbox in the combo's afterupdate event)?
--

John W. Vinson [MVP]