Tab controled form opens as blank rather than showing record

[HBTCLaura]

Hi,

I have looked all over but can't seem to find anyone else that's having the same problem as me!

I have the below tables which are all linked using EmpID

tblEmployer tblHealthandSafety tblVacancies tblComments
EmpID (PK) HthID (PK) VacID (PK) CmtID (PK)
EmployerName EmpID (FK) EmpID (FK) EmpID (FK)
EmployerAddress Last Review VacancyName Comment
EmployerTelephone ELI Expriry VacancyStatus CmtDate

I have a form that lists the names of employers and a link (ran by macro's) to view further details of the employer. By clicking this link a pop-up form opens with a tabbed control with each of the tables details on each tab. I have a record that has details on every tab and this works absolutly fine however, I have a few records that only have the employer details entered and nothing on the other tabs and when I click to open the pop-up for these the pop-up displays to enter a new record rather than showing the details.

I've attached a screen shot showing the macro used.

If anyone has any ideas as to why this is happening I will be very greatful for your help.

Thanks in advance

 

[HBTCLaura]

Sorry, my tables didn't post as formatted! Please see below

tblEmployer
EmpID (PK)
EmployerName
EmployerAddress
EmployerTelephone

tblHealthandSafety
HthID (PK)
EmpID (FK)
Last Review
ELI Expriry

tblVacancies
VacID (PK)
EmpID (FK)
VacancyName
VacancyStatus

tblComments
CmtID (PK)
EmpID (FK)
Comment
CmtDate