defaulting based on user entry

[eramirez]

Hi

I have a menu button set up where when selected, it runs a query asking for the user to enter a DATE. I want to use this DATE as the default value for the field. I am drawing a blank on this.

any suggestions would be appreciated.

Thanks
Enrique

 

[John Big Booty]

I'm not sure I understand what you are trying to achieve. Could you possibly step us through the process and explain what you want to happen at each step.

 

[eramirez]

sorry I wasn't more specific.

Basically what I want to achieve is to have a menu button that when pressed it will open up a specific form, but before opeing the form, the user will be prompted to enter a date (ideally showing a calendar). Once the user enters the date, the form opens and the date field is auto-populated with this date as well as every new record added until the user exits. Each time the form is opened, the user will be promted for the date and this date will be used to autopopulate every new record added and so on.

The form is specific for a facility and the date is the date of service. The facility can have multiple date of services which is why I don't want to use a default value. The user will be entering specific orders in batches that have the same date and I want to save time by autopopulating every next record with the date that was entered at the menu prompt.

I hope this wasn't more confusing. If there is a simplier way to achieve this, I welcome all suggestions.

Thanks again
Enrique Ramirez

 

[John Big Booty]

For the Pop Up calendar have a look at the Sample available in the Sample DB section of this forum.

From there you should be able use the OpenArgs portion of the DoCmd.OpenForm to pass the selected date to the Form you are opening. You would need to put some code in the Form's OnLoad Event, it would look something like;

Me.YourDateFieldName.Value = OpenArgs

 

[eramirez]

thanks for the help.