Hello,
I use a second form to add extra data to a record. Both records are linked by an ID.
Here's my problem :
When I want to open the second form, i do it with this code line :
DoCmd.OpenForm "frmVerschildrukmeters", acNormal, "", "[LokatieID]=[Forms]![frmInstallaties]![ID]", , acNormal
This results normaly in opening the corresponding record in the second form. So far so good, but when there is not yet a record corresponding in the second form, I get an error because there is nothing on the open form (because of the filter).
Is there a way to detect that there is no result from the filter ?
When there is no corresponding record, I want to create one with the correct ID automaticly filled in.
TNX in advance.
B.
I use a second form to add extra data to a record. Both records are linked by an ID.
Here's my problem :
When I want to open the second form, i do it with this code line :
DoCmd.OpenForm "frmVerschildrukmeters", acNormal, "", "[LokatieID]=[Forms]![frmInstallaties]![ID]", , acNormal
This results normaly in opening the corresponding record in the second form. So far so good, but when there is not yet a record corresponding in the second form, I get an error because there is nothing on the open form (because of the filter).
Is there a way to detect that there is no result from the filter ?
When there is no corresponding record, I want to create one with the correct ID automaticly filled in.
TNX in advance.
B.