> I am a new VBA programmer with moderate experience using
> macro's.  Here is what I am trying to do.  I want to
> create a Validation Rule property for a Control on a Form
> that prevents users from entering a date that is not
> between (within) the minimum and maximum date of a
> particular field within a table.  I have created 2
> seperate simple one field queries to capture the minumum
> and maximum dates of this field.  I have tried every which
> way to reference the values obtained from the queries
> witin the Validation Rule property sheet of the control
> with an expression but nothing works.  I must assume then
> that I must use a macro or VBA code to accomplish this
> task.  What is the best and simplest method of
> accomplishing this task?  All suggestions appreciated.  I
> want to use this as a learning tool since I have never
> tried this before.
> THANKS!!!! Van