fill field on form from subform

P

Phil

I am currently rebiulding a database that has had lots of bits added to it
and some parts do not relate to each other.

I have a form Events which has a subform called tblEventsLocation subform

the part of the database I am having problems with relates to dates. I
have a table [Events] with the field startdate and enddate and a table
[eventslocation] which store every date for the courses under [eventdate] and
[day] (which can be either 1,2,3,4,5 etc) at the moment I complete each field
seperately ideally I would rebiuld it completely and get rid of startdate and
enddate but almost all of the queries and forms are based upon these.

I have a form

what i would like to do is complete the subform base on tbleventslocation
and have startdate on the main form autocomplete when day=1 and enddate
autocomplete when it is the last day (the events can last from 1 day to 5
days or longer).

I know this is a convoluted way of doing things, but apart from rebiulding
everything (which I dont have time for) I can see no other way of doing it.

I hope you can understand what I am trying to do.
 
Top