I've done this sort of thing in the past but I can't remember how I did it; must be an age thing!
What I am wanting is to achieve is the following:
The set up at the moment is:
1: parent form: Manage existing customer records
Contains the following fields: CustomerID, Surname, Address etc and a button to open the Remedial Management form
2: pop up form: Remedial Management form
Contains the following fields: Surname, Issue, Date reported, Appointment Date etc
I have linked the fields using CustomerID = Surname and what I want is that the pop up form opens and shows the related fields to the specific customer record.
What is happening at the moment is the form opens showing nothing, unless there is already data existing in the table/query related to the customer record linked to the pop up, and to join the tables to show information I have to select the customer surname from the Surname drop down box.
Hope that makes sense? Any help is appreciated