Buttons appear numerous times and when clicking the text disappears

[tmcrouse]

When I load my main form for switchboardID, my buttons appear numerous times. I have 9 buttons on my main form and have a query as such for the buttons:

SELECT [Switchboard Items].ItemText


FROM [Switchboard Items]
ORDER BY [Switchboard Items].ItemNumber;

When I view the form not in design mode, it displays the items multiple times on the main page. My query is in record source.

The other issue is when I click on the buttons, the text disappears and then when I move mouse away it reappears.

[June7]

There are many reasons MS has deprecated the switchboard manager. For one, programmers don't like it.

I just built a switchboard as a test and the RecordSource sql is:
SELECT * FROM [Switchboard Items] WHERE [ItemNumber]>0 And [SwitchboardID]=TempVars!SwitchboardID ORDER BY [ItemNumber];

Looks nothing like yours.

[tmcrouse]

That does not work unless I create a single button and then a label for the text and it creates it so everything is displayed in a list. They want each item as a button. So, 9 buttons on the front page and I have to select itemtext.

[June7]

Sorry, don't understand that.

I created the switchboard with the wizard/manager. I did the same test a few days and built it up to the 8 buttons. Then went directly to the table to input record for 9th button. Did not check the RecordSource but the form worked.

[tmcrouse]

Maybe I need a label for each and just hide the label?

[tmcrouse]

I am not using Wizard. I used someone else form and altered it to what I needed. Let me try the wizard way and see what happens.
Of course maybe it is because I started with 9 buttons so I need to create 8 buttons first and then add the 9th?

[tmcrouse]

Still did not work. I will just delete this entire thing and start over. I am not using the wizard.

[June7]

If you are not using the wizard then what are you building? I have never implemented 'Switchboard', at least not as configured by the wizard.

I create a 'Menu' form with command buttons and VBA code in button Click events. Usually this 'Menu' form does not even have a RecordSource.

[tmcrouse]

Ugh. Why is this so hard. I am reading all through these books and cannot get this to work right. I re-created it and now all the buttons are there but overlapping the formheader. And when I attempt to hover or click on them the text in the button disappears.

[June7]

Without understanding the process you are using to create this object, cannot analyse the issue. I must be able to replicate.