Selecting Control to link to New Form

[stretch66]

Hi,

Have been developing an Employee DB which includes sickness records and interview information. Have mangaged to sickness records but now I need to link interviews to these specific records which is where I am having a problem.

All sickness records are shown on a sub form and I attached a button at the end of each record so that I can can add interview information that is linked to the sick record through SickID but just cannot get it to work.

Have attached relevant forms and tables and could really do with some help as am pulling my hair out here.

Cheers

 

[neileg]

Part of your problem is that you are basing your forms on tables. If you use queries (which is good practice) you can use data on one form to provide a criterion for the query to base the next form on.

 

[stretch66]

So I can create a query that links the ithe sickness record with an interview.

Will try and read up