D
datin
hi,
i have a subform called Results. i used this form when i need to type in
test results.so i used a button in Child form to call this subform. my
problem is when i call this subform it supposed to ready with Child_ID so i
just need to type in results data. it dont have problem when i just used
subform directly in Child form. i used button to call this subform because i
need to minimise display and not to confuse my staff when they type in the
data.
i set data entry : Yes
On Error GoTo Err_Command18_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Results subform"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_Command18_Click:
Exit Sub
Err_Command18_Click:
MsgBox Err.Description
Resume Exit_Command18_Click
my query:
SELECT [Table1 Query].Child_ID, [Table1 Query].test, [Table1 Query].A,
[Table1 Query].B, [Table1 Query].C, [Table1 Query].D, [Table1 Query].E FROM
[Table1 Query];
any idea to solve this problem?
i have a subform called Results. i used this form when i need to type in
test results.so i used a button in Child form to call this subform. my
problem is when i call this subform it supposed to ready with Child_ID so i
just need to type in results data. it dont have problem when i just used
subform directly in Child form. i used button to call this subform because i
need to minimise display and not to confuse my staff when they type in the
data.
i set data entry : Yes
On Error GoTo Err_Command18_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Results subform"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_Command18_Click:
Exit Sub
Err_Command18_Click:
MsgBox Err.Description
Resume Exit_Command18_Click
my query:
SELECT [Table1 Query].Child_ID, [Table1 Query].test, [Table1 Query].A,
[Table1 Query].B, [Table1 Query].C, [Table1 Query].D, [Table1 Query].E FROM
[Table1 Query];
any idea to solve this problem?