K
Kenny Robb
I am trying to write an event handeling database and I have done most
of it apart from some of the forms for the user to rnter data.
There are a number of tables all linked with the data organised for
minimum duplication.
Problem.
I have a form (FORMA) which pulls up some details from TABLEA about
the event. Important field is eventid as that will tie in the next
table
I then have a table which has a list of people (names and addresses
etc) who potentially can attend the event. (PEOPLE)
I have a form which then populates a table called EVENTATTENDANCE
which uses the eventid and a personid form the PEOPLE
What I want to be able to do is is have a sub form on FORMA which will
allow me to enter into another table (FEEDBACK) some information from
each of the people who attended the event. in otherwords when I go
into my subform I can drop down a list of people who attended the
event.
I can get it to give me the dropdown but when I use the condition on
the selection for the drop down iforms![forma]![eventid] but it seems
to work for the first event but when I scroll through the records in
the main form using the std navigators to get to an event when I
select the drop down in the sub form I get the list for the first
event.
I have tried using the requery onEntry to the form but I am now
getting a bit out of my depth as far as forms are concerned.
Any help would be greatly appreciated and hopefully there is enough
information here and it is not a difficult thing for those in the
know.
Thanks
Kenny
of it apart from some of the forms for the user to rnter data.
There are a number of tables all linked with the data organised for
minimum duplication.
Problem.
I have a form (FORMA) which pulls up some details from TABLEA about
the event. Important field is eventid as that will tie in the next
table
I then have a table which has a list of people (names and addresses
etc) who potentially can attend the event. (PEOPLE)
I have a form which then populates a table called EVENTATTENDANCE
which uses the eventid and a personid form the PEOPLE
What I want to be able to do is is have a sub form on FORMA which will
allow me to enter into another table (FEEDBACK) some information from
each of the people who attended the event. in otherwords when I go
into my subform I can drop down a list of people who attended the
event.
I can get it to give me the dropdown but when I use the condition on
the selection for the drop down iforms![forma]![eventid] but it seems
to work for the first event but when I scroll through the records in
the main form using the std navigators to get to an event when I
select the drop down in the sub form I get the list for the first
event.
I have tried using the requery onEntry to the form but I am now
getting a bit out of my depth as far as forms are concerned.
Any help would be greatly appreciated and hopefully there is enough
information here and it is not a difficult thing for those in the
know.
Thanks
Kenny