data not visible in subform

[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?

 

[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?

 

[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

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?


--

Graham Mandeno [Access MVP]
Auckland, New Zealand

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?

 

[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

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

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?


--

Graham Mandeno [Access MVP]
Auckland, New Zealand

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?