Displaying # of similar entries on a form

T

Trial & Error

I have a form that has Date and Time fields on it.
( I had to separate date and time... I know a combined date / time field
would be better)

I would like to have a small subform visible on the form that would read the
date and time being entered, and return a # of entries that have already been
made with the same date and time.
If at all possible, I would really like to subform to update as the date and
time are entered on the parent form... rather than having to finish and save
the current form.

How is this possible? What would be involved?
The more detailed the answer... the better...
Still familiarizing myself with Access.
 
T

Tom Wickerath

What you are describing is known as Query By Form (QBF). I have a sample that
I can send to you, if you send me a private message with a valid e-mail
address. This sample uses a fair amount of VBA code, so it may be a bit
overwhelming if you are just getting started in Access.


Tom

ZXaos 168@ WQcomc URast . Znet (<---Remove capitolized letters & spaces)
___________________________________

:

I have a form that has Date and Time fields on it.
( I had to separate date and time... I know a combined date / time field
would be better)

I would like to have a small subform visible on the form that would read the
date and time being entered, and return a # of entries that have already been
made with the same date and time.
If at all possible, I would really like to subform to update as the date and
time are entered on the parent form... rather than having to finish and save
the current form.

How is this possible? What would be involved?
The more detailed the answer... the better...
Still familiarizing myself with Access.
 
Top