How to make a pop up box in which a user can enter a date

[irishandy]

Simple problem except I can't work out how to do it.

I've a date field on a form. The subform data is linked to that date. I want the user to be able to change the date but only explicitly by clicking a button, being prompted to enter a date, then entering that date. The button should then update the field and requery the subform.

Any ideas on how I can achieve this? I know how to do all of the above except how to get a little pop up box. Ideally it would be similar to a msgbox except with a space to enter a date.

Thanks to any and all who respond.

 

[TheAceMan1]

How are ya irishandy . . . . .

Just a suggestion.

You could use the [blue]DoubleClick[/blue] event of the control to toggle lock/unlock editing (via the [blue]Locked property[/blue]) of the control. With a Msgbox to display its state.

The [blue]AfterUpdate[/blue] event would be used to verify proper data exist & requery the subform. With a final locking of the control.

For visual cueing of the locked condition, you could use conditional formatting . . . .

So . . . . . ya think?

See Ya! . . . . . .

 

[PHV]

except how to get a little pop up box
Take a look at the InputBox VBA function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[irishandy]

Thanks to both of you for your replies. The InputBox VBA function looks to be just what I need, so thanks for that PHV. Aceman - nice idea but I'll go with the inputbox.