General question about forms designed to navigate like a gui

[ehrpromotions]

I have a data entry/storage/reporting project that an access data base would handle well if the data entry part can be customized.



Essentially, can a form be designed to navigate like a gui. For example, instead of using a combo box to select one of 5 options, can each of the options be displayed in separate areas of the screen, and an option selected by clicking on that area of the screen? Depending on the option the vba logic would request data via manual entry, clicking on another gui, close the record etc.

I dont intend to do this myself, Im barely functional in Excel VBA, but I wont search for a VBA coder if this type of navigation isnt possible.

[ssanfu]

Not really clear on what you want, but I don't see why not. You could have buttons anywhere in a form to initiate a process.

[orange]

I agree with Steve --it isn't clear what you want.

I suggest that, if you are going to hire someone else to create a database application for you, then:
-make sure you clearly identify the requirement in simple English terms
-don't assume that the "contractor" knows/understands exactly what you are thinking
-offer some sample scenarios (inputs and outputs) to put your needs into context

[Micron]

I believe that if you can imagine the design or function, it likely can be done. That does not mean that just because it's possible that it should be done.
The picture I have when reading the requirements tells me it's both possible and practical, as you might see many variations of gui forms if you take notice whenever you go to places like the dentist, doctor, store, restaurant, etc.

[ehrpromotions]

Thanks for the replies. Perhaps what Im asking is can buttons be disguised as images/pictures.

An example: The top level of the "form" interface is a Christmas Tree (Happy Holidays all). The tree has ornaments and clicking on an ornament branches to code that then solicits data either in the usual formats (combo boxes, text etc) and possibly additional "clickable images". The latter might be pictures of video games, and clicking on the game records that user's "like".

[Micron]

Answer is yes, buttons can hold images. Also, image controls have click events. The latter may be more suitable.

[ehrpromotions]

Ahhh, "image controls" are new to me, it sounds like the solution. TY!