List Box Help Please

[Guest]

I have a subform on a main form. I have two list boxes in the sub form. I
want List box 2 to update when I choose from list box 1. This is what I
currently have.

Private.Sub 1st_ListBox_AfrterUpdate()
Me.1st_ListBox = ""
Me.1st_ListBox.Requery
Me.Requery

End Sub

Private Sub 2nd_ListBox_AfterUpdat()
Me.Requery

End Sub


I would also like my list boxes to have a default of Null.
I would appreciate any help as this is not working. Thank you in advance.

 

[Jeff Boyce]

Please provide a bit more description of what you want to accomplish.

"I want Listbox 2 to update" doesn't tell us much about what it is supposed
to do.

Since it all starts with the data, please describe the data you have
underlying these forms and listboxes...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Thank you for responding. I want to be able to pick an item in LIst box 1
and have additional info show up in List box 2 (eliminating need to select
from List Box 2). Selected items to be entered in table.

Thank you.

 

[Jeff Boyce]

I still have absolutely no idea what data you are using, how you have it
organized into tables, how you are pulling data from the tables to get to
your forms, or your listboxes, ...

Consider stepping back for a moment and offering us a fresh view (remember,
we can't see what you can).

Forget about "how" you want to do something for a moment ... and tell us
more about "what" (that would be, not "use two listboxes to show...", but
maybe "I want to see the information that accompanies a Product I pick on a
form").

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Okay - I want to see the information that accompanies an Item I pick on a
form. Basically, I want to eliminate as much data entry as possible. When
user picks an item I want a description of the item to show.

I have a table and I am using fields from the table for controls on my form.
I want to synchronize two list boxes using fields from the same table.

Thank you.

 

[Jeff Boyce]

It all starts with the data.

Please describe your tables.

Regards

Jeff Boyce
Microsoft Office/Access MVP