Subform dissappearing

[Guest]

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

?

 

[Guest]

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]

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.