temporary recordset.

S

Simeon Cheeseman

Hi.

I have a problem with my bookings database. The proccess follows on from a
form which selects the first, last name and house, these are then transfered
to another form which allows the user to select the dates to be booked in
for, the dates booked in should be displayed in a small subform on that form.
My problem is that I cannot figure out how to update or store several dates
temoprarily in the subform before evaluating them in the next step.
How could I do this?

Thnaks Simeon.
 
T

TonyT

Hi Simeon,

You don't explain why the dates need to be stored in a subform of the second
form, but it would be easier to store them in unbound textboxes on the second
form itself (visible or not) or in Dimmed variables available to that
procedure.
If you could post sample code we could see better what you are trying to
acheive and where it is going wrong. (most often naming syntax referring to
subforms)

TonyT..
 
S

Simeon Cheeseman

Hi Tony.

The subform is used to show those dates that the user has put as 'pending'
for bookings (multiple bookings), i.e. these are some of those they intend to
book which have to be shown to avoid double booking, I already have unbound
text boxes for the entry of the dates.

Thanks Simeon
 
T

TonyT

Hi again,

In which case can you not just use something like,

Forms!ParentForm!SubForm.Form.txtToStoreDate = Me.txtWithDateIn (on main form)
in the afterupdate event of txtWithDateIn (this is the control that the date
is actually typed into originally.

It still seems like duplicating data to me, to enter dates in one place and
then move that data to another place, while still being able to (more easily)
access the data from the main form. But obviously you have reasons for this,
just it's a bit hard to grasp what you are actually trying to acheive, so my
reply may not be what you are wanting. If it isn't please post sample code of
what you have tried so far, it will make it much easier to try to help you.

TonyT..
 
Top