R
Ruth
I am entering data into a subform to be stored into a table. The data is in
the table but not visible in the subform. How can I fix this?
the table but not visible in the subform. How can I fix this?
G
Graham Mandeno
Hi Ruth
More information please!
Is the subform linked to the main form? (LinkMasterFields and
LinkChildFields)
If so, what are the values of the above two properties of the subform
control?
How did the data get into the table? By entering it into the subform? So
are you able to enter *new* records into the blank subform?
What are the settings for the following properties of the subform:
AllowEdits, AllowAdditions, DataEntry?
More information please!
Is the subform linked to the main form? (LinkMasterFields and
LinkChildFields)
If so, what are the values of the above two properties of the subform
control?
How did the data get into the table? By entering it into the subform? So
are you able to enter *new* records into the blank subform?
What are the settings for the following properties of the subform:
AllowEdits, AllowAdditions, DataEntry?
R
Ruth
Yes, the subform is linked to the main form.
The values of the 2 properties fo the subform control are
1)Names selected from a combo box and
2)Date selected from a pop up calendar
Data gets into the table by selecting the above information into the subform
Settings for the main form for
allow edits = yes
allow additions = yes
data entry = no
--
Ruth
The values of the 2 properties fo the subform control are
1)Names selected from a combo box and
2)Date selected from a pop up calendar
Data gets into the table by selecting the above information into the subform
Settings for the main form for
allow edits = yes
allow additions = yes
data entry = no
--
Ruth
Graham Mandeno said:
G
Graham Mandeno
Hi Ruth
OK, so as you add records to the subform, the name and date fields should be
automatically populated with the selected values from the main form. Is
this happening?
The LinkMasterFields property should have the names of the two main form
controls separated by semicolons. For example:
cboSelectName;calSelectDate
LinkChildFields should have the names of the corresponding *fields* in the
subform's recordsource. For example:
NameField;DateField
Is the problem that you able to add records, but when you go back later and
select the same name and date you don't see them any more?
Also, I asked for the three properties of the subform, not the main form
--
Graham Mandeno [Access MVP]
Auckland, New Zealand
OK, so as you add records to the subform, the name and date fields should be
automatically populated with the selected values from the main form. Is
this happening?
The LinkMasterFields property should have the names of the two main form
controls separated by semicolons. For example:
cboSelectName;calSelectDate
LinkChildFields should have the names of the corresponding *fields* in the
subform's recordsource. For example:
NameField;DateField
Is the problem that you able to add records, but when you go back later and
select the same name and date you don't see them any more?
Also, I asked for the three properties of the subform, not the main form
--
Graham Mandeno [Access MVP]
Auckland, New Zealand
Ruth said: