Dear Sir/Madam, I have a worksheet as below: Column A Column B Column C Row1 David Boy Form1 Row2 Susan Girl Form7 Row3 Mary Girl Form1 Row4 John Boy Form1 I want to retrieve specific record like "Boy" and "Form1"

I managed to get it to work, ButtonMenu.Parent.Key gave me errors so I cahnged to ButtonMenu.Parent.Index and all is well. thanks for the pointer SteveC On Jul 26, 9:48 am, SteveC <adm...@yahoo.com> wrote: Thanks, how would I use that? A little sample would help me . SteveC On Jul 26, 8:59 am, "Jan Hyde (VB MVP)" <StellaDrin...@REMOVE.ME.uboot.com> wrote: SteveC

SteveC <admlcl@yahoo.com>'s wild thoughts were released on Thu, 26 Jul 2007 08:52:40 -0700 bearing the following fruit: I'm probably missing something obvious, but I'm have trouble with the dropdown menu on the toolbar.How do I code the Toolbar1_ButtonMenuClick so that I when I click Button1 Menu item3 I get Form3 to load and if I click Button5 Menu item3 I get Form7 to load.Basically

Desing settings: Form.AllowAdditions = TRUE may change in code to FALSE. With FALSE there were no records in main form and thus link field was empty... and I got an error message. It's very difficult to handle dynamic settings correctly if I don't know HOW!!! There's NO information about how to handle code in debug and break. To me it seems that if I need to change something in code I always

Thank you again. I will do just that and I will make sure I post that these solutions that you gave me work PERFECTLY!!!! Also, can you think of any reason that the form, which is one of the DoCmd exhibits that I want to produce, will not print out and the form opens up instead of doing its work in the background. Code: Dim strCBA As String , WhereCondition As string