Using table data as button captions

[jecanne]

Hi,



I'm fairly new to using VBA and wanted some help with a procedure. I want the caption for buttons in my Form to be pulled from a record in a table. Additionally, I want the name of the related form or report opened from the button to be pulled from the same record. I've been looking into this and it seems like using DAO is one option, but I'm not familiar with this. I've already go the table set up, that was easy enough. Any help or sample code would be appreciated...thanks!

[RuralGuy]

Are you going to make all of your forms defined this way? It is certainly do-able but why would you want to?

[jecanne]

No, just the main menu. I have a main menu form and an associated table. The table is small with just three fields:

tblMainMenu (ID, Caption, Item)

The main menu is supposed to pull data from that table's records to populate button captions and know which form/report to open. It's just accessing that data from the table that I don't know how to do...

I don't want to do this lol. I have an online class and my instructor isn't very helpful. I've read the chapters he asked us to but they don't seem to relate to what he's asking for. I've managed to come up with everything he's asked thus far, but this week has been a struggle.

Just to clarify, I'm not asking for someone to cheat for me, just a little help.

[RuralGuy]

In that case, what you are describing is already built into Access. It is the SwitchBoard and works just as you are describing. If you let it build you one you can see how it uses tables and modifies the Captions on each button.

[jecanne]

Oh, and we can't use switchboards Sorry, forgot to mention that! I know, it's stupid. I might be able to figure it out, I'm looking at something from a programmer's reference right now about looping through recordsets with DAO...I'll let you know if I find anything.

[RuralGuy]

Here's a link about DAO Recordsets that you may find helpful. http://www.baldyweb.com/BuildSQL.htm

[jecanne]

Thanks for the link, it was helpful. I think I figured this out now...I guess my question really was "How do I Extract Data from a record in a DAO Recordset?"
http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

I just tested it on one button caption, and it works. Now I just have to loop through and write some quick macros to open the form/reports. Thanks for the help!

[RuralGuy]

You're welcome. Have fun. You can use the Thread Tools at the top of the thread to mark this thread as Solved.