Subform not showing data

[Novice1]

I have two forms. The first form has individual data to include the person's Social Security Number (SSN). I have another form (subform) that has other data to include the person's SSN.

I added the subform to the form (linked the SSN). Unfortunately, only the SSN field appears in the subform. None of the other data in the subform appears in the subform.

What could be causing this problem? Thanks

 

[vbaInet]

When you created the subform did you include other fields that you wanted to see?
Is this subform also a form object or was it created from a table/query?

 

[Novice1]

Yes, the subform includes other fields I want to see.

The subform is a form object.

The form and the subform have the SSN as the shared field.

When I enter the SSN on the form the subform isn't populated. Only the SSN appears in the subform, which suggests to me the form and subform are connected.

Not sure what I'm doing wrong.

 

[JHB]

And what is the recordsource for the subform, a table/query?
And does that have the fields + values in it, you want to show in the subform?

 

[Novice1]

The recordsource for the subform is a query. Yes, there are 4,000+ records in the recordsource.

The SSN in the form is linked to the SSN in the subform. When I place the SSN is the form, the SSN appears in the subform (appears linked); however, none of the other fields have data.

When I open the subform (by itself), I can see the data but not when it's a subform.

 

[JHB]

Sound strange, could you post your database with some sample data, + name of the form zip it.
You do not set the subform to Data entry by code, do you?

 

[vbaInet]

In the absence of your db, since it's returning data but only showing one field then it would indicate that your subform is a datasheet. If this is the case then you could:

1. Look carefully at the controls on your form to ensure that their Visible property is True
2. Load the subform as normal (i.e. as a datasheet) and unhide the columns
3. Open the subform in design view and ensure that all your controls are bound to a field - you'll find this in the Control Source property of your control (e.g. textbox).
3. Double check your record source to ensure that all the necessary fields are set to Show.