New Record in Subform Help

[SpdRacerX]

I have a Subform of one Form, where the fields are autofilled off of the main form for a New Record.



However, on a second Subform of a different Form, this is not the case.

I have searched the properties, etc. of both Subforms and they are identical except for the Master/Child Links.

Any suggestions?

[sstrauss87]

Link the fields.

[SpdRacerX]

In the one that works, I linked Name & Discharge Date in both the Master and Child Links.

In the second one that doesn't work, I tried to link Name & SSN but it wouldn't let me do both (blank records). When I switched it to just SSN, the records appeared but the new record was not filled out like the other subform.

[sstrauss87]

In the property sheet for the subform you should be able to like multiple fields separated by a semi colon.

Link Master Fields : CalibEquipmentID;CalibCompany
Link Child Fields : CalibEquipmentID;CalibCompany

[SpdRacerX]

The 2nd SubForm's RecordSource is a Query, which has what I believe is called an Expression Field (CONCATENATE of First Name & Last Name from Patient Table). Could this be the problem or am I missing something else?

I set the Relationships between appropriate tables.

Tried the Link Master & Link Child Fields.

The only records that show up is when I have SSN in the Master/Child Fields, but it still doesn't auto-fill the Name Field in the Sub-Form.

[sstrauss87]

Can you try filling in the name using a dlookup based on the ssn?