Hi hi hi hi,

  Glad to come again :)...

  This a kind of issue which iam thinking for most of time ...
  I want to creating an dialog box in access with will show three button..

  i.e.
      In a form there are four main categories and there are more than 5 sub categories (i.e. tables) under each main categories.

      The sub categories (tables) contain entry form & report generating forms.. (from each table then totally 40 forms are there).

  Now the issue is when I click the main category it will loop to sub categories forms ... in that five sub categories are been display ..when user click an sub category name then an dialog box should appear show buttons as Entry,Report & cancel . If user selected the Entry it should go to Entry form , If user selected the Report then should go to Report generation form ...as like that ...

 Any body having Idea to solve this is VB or in Access macro....any thing

  thanks in advance ...

 yours,
 anukagni @ pap

Learn as you can..
------------------------
pap...

Instead of using a dialog box, you can either create a form with the 3 buttons on it (make it pop up and modal) or for the on click event of the sub category, you can have 3 buttons appear on the existing form. Be sure to make them disappear if another category is clicked. For the 3 buttons, use a select case to decide what action each takes. For example, if they open another form or report, use select case and check the category and sub category selections, and choose the proper report / form name based on the choices.

Did that help?


mmcdonal

I had tried it donal it give an rough look to my database!. my boss want to look cool .....


anukagni

A form looks rough? Maybe you are not designing them correctly.

Try changing the border to thin or dialog, remove all the buttons and record selectors and scroll bars and dividing lines, etc, and then add the buttons you need, a good title, and some graphic background, and THAT will look much better than any application dialog box - which looks klunky, and definitely not cool. You can even do some graphic buttons, with mouse over effects, etc.

Did that help?

mmcdonal