subform didnt copy item

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?
 
N

NetworkTrade

you Dim stLinkCriteria and put it in the open form argument

but there is no value for it
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top