This is bizarre, what happened to my form???

  • Thread starter Thread starter Sandra
  • Start date Start date
S

Sandra

Just when I thought I had this ready to go I have a form
that is acting strange. This is a form with a subform
that has Yes/No checkboxes. If there are no linked
records in the subform the checkboxes don't show up at
all, like the subform isn't there but it is because the
square and record selector is there, everything else is
blank.

If I go into the underlying table and enter a value in
the linked field to the main form, then the subform shows
up correctly, checkboxes are there but you can't select
them, i.e. input any data into the subform.

This was working a few days ago, and I have a older
backup of this db that works OK. What the heck have I
done? I have the DataEntry property set to No, all the
other Allows are set to Yes, the relationships are OK,
and the correct Child and Master fields are linked.

Help!

Sandra
 
Sandra said:
Just when I thought I had this ready to go I have a form
that is acting strange. This is a form with a subform
that has Yes/No checkboxes. If there are no linked
records in the subform the checkboxes don't show up at
all, like the subform isn't there but it is because the
square and record selector is there, everything else is
blank.

If I go into the underlying table and enter a value in
the linked field to the main form, then the subform shows
up correctly, checkboxes are there but you can't select
them, i.e. input any data into the subform.

This was working a few days ago, and I have a older
backup of this db that works OK. What the heck have I
done? I have the DataEntry property set to No, all the
other Allows are set to Yes, the relationships are OK,
and the correct Child and Master fields are linked.
Click to expand...

Is the query or SQL statement that the subform is bound to editable? My
guess is no.
 
This subform is bound to a table called RCampaigns.
There is no query, and at this point, no SQL. The
heirarchy for this entire form schema is:

PeoplePlaces form - Main page of tabbed form bound to
PeoplePlaces table by PPID. This is for input of master
record of a donor. Within this main form is a subform
called PPCampaigns, PK is PPCID, that allows data about
donor campaign preferences to be linked to a master
record in PeoplePlaces by PPID. This form is checkboxes,
identical to the RCampaigns checkbox form (except the
link keys of course).
Second tab contains Relations subform - This is
subform,PK is RID, that allows for multiple "persons"
records to be associated to the master record via PPID.
RCampaigns sub-subform - Subform to the Relations
subform, PK of RCID, allows data about volunteer support
interests to be linked to a record in the Relations table
via RID.

Nothing fancy about this, the only query used is a sort
query on the PeoplePlaces table to alphabetize the form
records for display in the main form. All the other
forms are based directly on the underlying tables.

The checkbox form - PPCampaigns - works fine in the main
form. The checkbox form - RCampaigns - in Relations
subform does not work.

Any ideas?

Sandra
 
Well, I have recreated the event which seems to trigger
making this form non-functional. I make a copy of a
previous version of the db and was reconstructing some of
the forms, etc. Access asked if I wanted to save the
changes...then said this would reset the Project? I hit
OK and after than the subform was no longer functional,
just like before. What am I doing wrong, and how do I
avoid this in the future?

Sandra
 
Back
Top