Macros with dialog boxes with multiple options

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have been asked to create some macros to follow a decision making process
someone has flow-charted out for me.

Basically, on opening a form, I will be required to get Access to check for
related records to the current record on view, and depending on its findings,
return a dialog box with several choices, including setting up a new record
for a customer if they don't already exist, reviewing their record in a form
based on an archive table if they did exist once and now exist in an archive
table, or open another form with the customer details already in, in which we
can enter any purchase data.

I am familiar with macros and conditions in macros. I am familiar with
attaching a macro action to an event or to a button. I know I can generate
message boxes (msgbox), but don't know how to specify different options from
here. I wish I could attach the flow chart for you to view. It would
probably make more sense than this request!

I have a feeling that a module will be required. Modules are not my forte;
I haven't really created one myself before. If anyone could offer any
advice, or help for a module beginner, then that would be great.

Thanks guys.

Take care,

Karen
 
Karen,

My first impression here is that you are stuck on the point of using a
MsgBox. It seems to me that it would be better to think in terms of a
little form, which you pop up according to which conditions are
satisfied in your macro. This will give you a lot more flexibility than
a standard MsgBox, including the option to have further command buttons
on your dialog form, which themselves can run macros, which is what it
sounds like you need.
 
Back
Top