Sub-Form pointer problem

vtrm

Registered User.
Local time
Today, 14:24
Joined
Jun 8, 2005
Messages
21
I have 2 tables:
EMPMAST (3 fields: empid, empname, emppost) &
PAYTRX (3 fields: empid, benfcode, amnt)

I made a Mainfrm in which I display all records from EMPMAST (irrespective of whether they have any record in PAYTRX or not).
In the subFrm, I display all records from PAYTRX and have linked the Master & Child Fields as empid

I have a problem when I Close the MainForm. If my mainform is positioned at a record which has records in subform, there is no problem. But if the MainForm employee DOES NOT have any record in subfrom, I get a message "No current record" when I close.
 
Have a look at the attached sample;
 
Last edited:

Users who are viewing this thread

Back
Top Bottom