Sub-Form Not Getting Relevant Record (1 Viewer)

Ashfaque

Student
Local time
Today, 07:17
Joined
Sep 6, 2004
Messages
741
Hi,

My sub-form is not displaying relevant record as per header form. What would have gone wrong?

Both tbls are on SQL Server and linked in my Access db. Headform has no issue it is bringing the desired record as selected in Combo but the relevant record is not displying in sub form.

1. Linked fields are OTID, EMPNUM and OTDate
2. Main tble has primary key on OTID where as footer tble has same field with no primary key set.
3. While placing sub form in main form, I have linked them with 2 more field other than OTID. Those are EmpNum and OTDATE.

Now my subform is not reading the relevant data. I even deleted old records and add new and then recalled by choosing record from main form combo but still same.

Can anyone help me please...
 

Gasman

Enthusiastic Amateur
Local time
Today, 02:47
Joined
Sep 21, 2011
Messages
8,062
How have you linked the additional fields.?
I have only ever used single field, but perhaps & could be used.
 

Ashfaque

Student
Local time
Today, 07:17
Joined
Sep 6, 2004
Messages
741
How have you linked the additional fields.?
I have only ever used single field, but perhaps & could be used.
Thanks Gasman,

After seeing your response it clicked me and used single field only and it worked out.

Thanks a lot
 

Users who are viewing this thread

Top Bottom