Subform dissappearing

[Paul]

Following up fom my previous question earlier. I have a subform which
contains a number of combo boxes. The Parent form is opened from the Main
Contact form and the child subform is placed in this parent form. The problem
is once I make any choices on the subform, close the form and reopen it the
subform dissappears. If I go back into the table delete the field info and
reopen the form it shows again. Any ideas. What am I linking wrong, if I go
inot design mode and try and go into form mode it comes up with error saying
either criteria problem or refernce too complicated???? and displays
blank,,,,anyone?????

Paul

 

[Dirk Goldgar]

Following up fom my previous question earlier. I have a subform which
contains a number of combo boxes. The Parent form is opened from the
Main Contact form and the child subform is placed in this parent
form. The problem is once I make any choices on the subform, close
the form and reopen it the subform dissappears. If I go back into the
table delete the field info and reopen the form it shows again. Any
ideas. What am I linking wrong, if I go inot design mode and try and
go into form mode it comes up with error saying either criteria
problem or refernce too complicated???? and displays
blank,,,,anyone?????

It sounds like there's something wrong with the suibform's recordsource
query or with its linkage to the main form. What are ...

(a) the recordsource of the main form (if a query, post the SQL)

(b) the recordsource of the subform (if a query, post the SQL)

(c) the Link Master Fields property of the subform control

(d) the Link Child Fields property of the subform control

?

 

[Paul]

It sounds like there's something wrong with the suibform's recordsource
query or with its linkage to the main form. What are ...

I have no queries set up tolink the forms but the following record sources

(a) the recordsource of the main form (if a query, post the SQL)

Record source of the main form is sessionplanner, which has a default value
field linking it to the Contact form ( The contact form being the initial
form that forms the route to most forms!)

(b) the recordsource of the subform (if a query, post the SQL)

The record source of the subform is sesschoice (the name of the subform
representing the session choices that have been made) This includes a
sessionchoiceID autonumber. In my table for the sesschoice subform I have a
field ContactID and sessionplannerID fields. I have tried to insert these
onto the subform and link it to the main form using both of these but still
as soon as any data goes into my sesschoice table it wont appear next time I
open it.

(c) the Link Master Fields property of the subform control

I seem to have both the master and child field properties set to
sessionplanID, I think this could be my problem!?? Could you advise which
should be referncing what?

(d) the Link Child Fields property of the subform control

?

Thanks Dirk

 

[Dirk Goldgar]

I have no queries set up tolink the forms but the following record
sources
Record source of the main form is sessionplanner, which has a default
value field linking it to the Contact form ( The contact form being
the initial form that forms the route to most forms!)

So [sessionplanner] is the name of a table? What is the primary key of
that table? Is ContactID a foreign key in that table? Just out of
curiosity, what are the other fields in that table?

The record source of the subform is sesschoice (the name of the
subform representing the session choices that have been made)

I don't think I understand you. The recordsource of a form or subform
can't be another form or subform; it has to be a table or query. What
are the actual tables involved here, and what do they represent? It
sounds like there's a table for Contacts, a table called
"sessionplanner" (though I don't really understand what it represents),
and a table named "sesschoice" representing for session choices. It
would help to understand these things more clearly, and to know how they
are related. Please post the name and relevant fields of each table,
and indicate which field(s) are the primary key of each table, and which
fields in each table are foreign keys to another table.

This
includes a sessionchoiceID autonumber. In my table for the sesschoice
subform I have a field ContactID and sessionplannerID fields. I have
tried to insert these onto the subform and link it to the main form
using both of these but still as soon as any data goes into my
sesschoice table it wont appear next time I open it.

That srongly implies an error in the subform linkage, but I'm afraid my
understanding is still too cloudy to pin it down for sure.

I seem to have both the master and child field properties set to
sessionplanID, I think this could be my problem!?? Could you advise
which should be referncing what?

It sounds like you probably need to be linking on both SessionPlanID and
ContactID, but I can't be sure yet.

 

[Paul]

Hi Dirk I dont think that a subform was the best way of doing what I was
trying to do!
I have 7 combo boxes that contain a selection of dif workouts that are input
onto the databse using dif forms. I want to be able to choose my clients
exercise routine for each day and when i click the command button, a report
will run choosing the specific choices made. This I am finding tricky!! I can
manage to run a query for each type of workout to see if it has been selected
in the combo boxes but if I try and add more tyes of workout to the query
unless it finds data for each one it displays nothing.
What is my best plan of action????

I have no queries set up tolink the forms but the following record
sources
Record source of the main form is sessionplanner, which has a default
value field linking it to the Contact form ( The contact form being
the initial form that forms the route to most forms!)

So [sessionplanner] is the name of a table? What is the primary key of
that table? Is ContactID a foreign key in that table? Just out of
curiosity, what are the other fields in that table?

The record source of the subform is sesschoice (the name of the
subform representing the session choices that have been made)

I don't think I understand you. The recordsource of a form or subform
can't be another form or subform; it has to be a table or query. What
are the actual tables involved here, and what do they represent? It
sounds like there's a table for Contacts, a table called
"sessionplanner" (though I don't really understand what it represents),
and a table named "sesschoice" representing for session choices. It
would help to understand these things more clearly, and to know how they
are related. Please post the name and relevant fields of each table,
and indicate which field(s) are the primary key of each table, and which
fields in each table are foreign keys to another table.

This
includes a sessionchoiceID autonumber. In my table for the sesschoice
subform I have a field ContactID and sessionplannerID fields. I have
tried to insert these onto the subform and link it to the main form
using both of these but still as soon as any data goes into my
sesschoice table it wont appear next time I open it.

That srongly implies an error in the subform linkage, but I'm afraid my
understanding is still too cloudy to pin it down for sure.

I seem to have both the master and child field properties set to
sessionplanID, I think this could be my problem!?? Could you advise
which should be referncing what?

It sounds like you probably need to be linking on both SessionPlanID and
ContactID, but I can't be sure yet.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Dirk Goldgar]

Hi Dirk I dont think that a subform was the best way of doing what I
was trying to do!
I have 7 combo boxes that contain a selection of dif workouts that
are input onto the databse using dif forms. I want to be able to
choose my clients exercise routine for each day and when i click the
command button, a report will run choosing the specific choices made.
This I am finding tricky!! I can manage to run a query for each type
of workout to see if it has been selected in the combo boxes but if I
try and add more tyes of workout to the query unless it finds data
for each one it displays nothing.
What is my best plan of action????

Can you explain a bit more about the logical "entities" (people, places,
things, activities) that your database is modeling? For example, you
seem to have these, if I've understood what you've said so far:

+ Clients

+ Types of Workout (what would be examples of these?)

+ Exercise Routines (composed of several different types of
workouts? Do they have a particular order?)

+ "Days" (of the week? Are we associating each exercise routine with
a specific day of the week for a particular client?)

Are you a personal trainer, or something of that sort?

It seems to me, from the little I've seen, that you probably need a
three-level hierarchy of data:

Client
Day of the Week
Activities (for that client on that day of the week)

I still think a main form/subform arrangement would be the way to go
here. The main form would show the client record, while you would
either have an unbound control to choose a day of the week and a single
subform linked by client ID and day of week, so that it shows the
activities that make up the plan for that client on that day; or else
you would have seven (?) subforms, one for each day of the week
(probably all showing the same form object, just filtered differently).
Either way, the subform would be in continuous form view, and each
record would contain a combo box in which you would select from among
the available workout types.

But all that is based on very little information about what you're
really trying to do. More information = better advice.