I cant seem to get dates!

[Benjamin Bolduc]

Hi everyone

Ive been trying all day to get a button on one of my forms to work right. Let me explain what i need it to do:

I just need it to open a Message box with a place to type in a date and then use that value on it's respective report.
You see, I make production schedules through access but the production days do not follow any logical order. I have a form where you enter the production information and a button that prints a Pre-made report based upon it. I know I could just open the report on its own and type in the date, But I need it to be user freindly.
If anyone has any code or ideas for this interactive dialog box, I would greatly appreciate it.
Thanks!

 

[Rich]

Use a custom built form which looks like an input box, use an unbound text box and reference that in the reports underlying query. Or just add [EnterStartDate] in the criteria for the same query's date field.
HTH

 

[simongallop]

Or the lazy option is to use the InputBox function. Same as messagebox except that it has a built in textbox

HTH