make a form pause for user to select from drop down list.

  • Thread starter Thread starter CD Tom
  • Start date Start date
C

CD Tom

I'm building data for a report and after the data is built I prompt the user
as to how they want the data to be displayed, they can display by individual
or by a category, if they select by Individual I make visible the combo box
where they can select the individual the problem I'm having is that even
though I set the focus to the combo box the program just continues on without
any pause. I need the program to pause on the combo box so the user can
select the individual and I will have the emp# to lookup by. Does anybody
have an answer. Thanks for any help.
 
Howdy, CD
Saw you making smoke on the cover of The Cowby Chronicle.

The only way to pause code is to open a form in dialog mode
Docmd.OpenForm "SomeForm", , , , , acDialog

It will pause until the form closes. You may need to consider using this
approach and passing the value back to the other form when the dialog form
closes.
 
Oh how do you pass that information back?

Klatuu said:
Howdy, CD
Saw you making smoke on the cover of The Cowby Chronicle.

The only way to pause code is to open a form in dialog mode
Docmd.OpenForm "SomeForm", , , , , acDialog

It will pause until the form closes. You may need to consider using this
approach and passing the value back to the other form when the dialog form
closes.
Click to expand...
 
Quite a surprise, I helped them do the scoring. Are you still active in
Cowboy action?
I thought that was going to be the only way, isn't there a pause command
that I could put after the dialog box and then in the after update make it
continue?
 
Yep, I was out shooting Saturday.

You can pass the value back to the calling form by pushing the value to it.
I would use the dialog form's Unload event. Assume it has a combo on it and
you are passing it back to a combo on the calling form:

Forms!CallingFormName!cboSomething = Me.MyCombo

As to positioning, you could use the MoveSize method in the dialog form's
Load event.
 
Back
Top