Need Duplicate List Box

newbie · #1 05-08-2009, 10:33 AM

I have a form that contains tab. Tab 1 and 2 display information based off of a list box selection. The list box is identical on both tabs. I would like for them to by in sync. So, if a user selects item 1 on tab 1 when they go to tab 2 item will will be highlighted in the listbox. Is this possible?

RuralGuy · #2 05-08-2009, 01:21 PM

If you put just one ListBox on the form instead of a page of the tab, it will show up on both tabs. Does that help?

newbie · #3 05-08-2009, 01:23 PM

That is how I had it originally, however the list box does not pertain to all the other tabs that I have, so I was loosing a lot of space to display information.

RuralGuy · #4 05-08-2009, 01:55 PM

I thought you only had two tabs, sorry. How about playing with setting it invisible when you are on a page where you don't want it? You can use the Tab Control's Change event for this.

newbie · #5 05-08-2009, 02:13 PM

Can you give more detail on this option? I placed the listbox on the form, so it now displays on all of my tabs (pages). Then I went to one of the pages I do not want the list box to be visible on and accessed the properties/events. The only events I can see are On Click, On Double Click, On Mouse Down, On Mouse Move, and On Mouse Up.

RuralGuy · #6 05-08-2009, 02:33 PM

You are on a Tab Page. You need to select the TabControl which is usually named TabCtl & number. The Index of the TabControl tells you what page you are on so you can just have a case statement to set the visible property of the ListBox.

Code:

Private Sub TabCtl0_Change()
   Select Case Me.TabCtl0.Value
      Case Is < 2
         Me.ListBoxName.Visible = True
      Case Else
         Me.ListBoxName.Visible = False
   End Select
End Sub

...using your control names of course.

newbie · #7 05-11-2009, 06:26 AM

You are amazing!!! This worked perfect. This coding stuff is adicting :0)

Thanks for all you help.

RuralGuy · #8 05-11-2009, 07:45 AM

Glad that worked for you and you're welcome. Try the link in my sig.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
List box to populate other list boxes	Nathan	Forms	0	03-03-2009 04:22 PM
Duplicate command button	brettg	Database Design	1	08-04-2008 02:16 AM
Duplicate add to new table	horseyshoe	Access	3	09-01-2006 05:51 AM
Which duplicate?	grgerhard	Import/Export Data	1	05-27-2006 04:19 AM
duplicate autonumber	rayc	Access	0	01-16-2006 06:57 AM