command button to open subform

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

because my form is too crowded. so that I would like to move the subforms to
a different page.

so i had make a command button to open a subform.

how can i change the following command line, so that i can pass one more
value [job_item] ?

stLinkCriteria = "[job_no]=" & "'" & Me![job_no] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Thanks.
Joe
 
Hello Joe,

If the data in job_item is text, then change the line as follows:

stLinkCriteria = "[job_no]=" & "'" & Me![job_no] & "' And [job_item] =
'" & SomeValue & "'"

HTH,

Neil.
 
Actually, user will need to [job_no] & [job_item] at form A and it had a
button to open a subform.
and job_item is text.
so i want to pass the job_no & job_item to subform and display.

do i need to change the command to:
stLinkCriteria = "[job_no]=" & "'" & Me![job_no] & "' And [job_item] = '" &
"'" & Me![job_item] & "'"


Neil said:
Hello Joe,

If the data in job_item is text, then change the line as follows:

stLinkCriteria = "[job_no]=" & "'" & Me![job_no] & "' And [job_item] =
'" & SomeValue & "'"

HTH,

Neil.

Joe said:
because my form is too crowded. so that I would like to move the
Click to expand...
subforms
to
a different page.

so i had make a command button to open a subform.

how can i change the following command line, so that i can pass one more
value [job_item] ?

stLinkCriteria = "[job_no]=" & "'" & Me![job_no] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Thanks.
Joe
Click to expand...
Click to expand...
 
Yes Joe,

You would need to change the strLinkCriteria as below.

stLinkCriteria = "[job_no]='" & Me![job_no] & "' And [job_item] = '" &
Me![job_item] & "'"

HTH,

Neil.

Joe said:
Actually, user will need to [job_no] & [job_item] at form A and it had a
button to open a subform.
and job_item is text.
so i want to pass the job_no & job_item to subform and display.

do i need to change the command to:
stLinkCriteria = "[job_no]=" & "'" & Me![job_no] & "' And [job_item] = '" &
"'" & Me![job_item] & "'"


Neil said:
Hello Joe,

If the data in job_item is text, then change the line as follows:

stLinkCriteria = "[job_no]=" & "'" & Me![job_no] & "' And [job_item] =
'" & SomeValue & "'"

HTH,

Neil.

Joe said:
because my form is too crowded. so that I would like to move the
Click to expand...
subforms
to
a different page.

so i had make a command button to open a subform.

how can i change the following command line, so that i can pass one more
value [job_item] ?

stLinkCriteria = "[job_no]=" & "'" & Me![job_no] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Thanks.
Joe
Click to expand...
Click to expand...
Click to expand...
 
Thanks for your help.

I had used the code you provided. but it prompt out a box to ask me the
job_scode (previously called job_item).
http://www.efilehk.org/pp/jb_init2.jpg

And i had captured the screen of my application.......

Form [Job Initiation] included a subform [Job Details].
http://www.efilehk.org/pp/jb_init1.jpg

User need to input job no. and subcode. and there is a button for each job
[job no.+ subcode].

so i want to pass the job no. and subcode to Form [Job Transaction], but i
am not success to pass the job_scode.
http://www.efilehk.org/pp/jb_init3.jpg

Besides, when we addd/edit a record, Access will automatically add a row at
the bottom and had a [*] on left hand side.
Can i disable this features?
http://www.efilehk.org/pp/jb_init4.jpg

thanks !
Joe



Neil said:
Yes Joe,

You would need to change the strLinkCriteria as below.

stLinkCriteria = "[job_no]='" & Me![job_no] & "' And [job_item] = '" &
Me![job_item] & "'"

HTH,

Neil.

Joe said:
Actually, user will need to [job_no] & [job_item] at form A and it had a
button to open a subform.
and job_item is text.
so i want to pass the job_no & job_item to subform and display.

do i need to change the command to:
stLinkCriteria = "[job_no]=" & "'" & Me![job_no] & "' And [job_item] =
Click to expand...
'"
&
"'" & Me![job_item] & "'"


Neil said:
Hello Joe,

If the data in job_item is text, then change the line as follows:

stLinkCriteria = "[job_no]=" & "'" & Me![job_no] & "' And
Click to expand...
Click to expand...
[job_item]
=
'" & SomeValue & "'"

HTH,

Neil.

because my form is too crowded. so that I would like to move the subforms
to
a different page.

so i had make a command button to open a subform.

how can i change the following command line, so that i can pass one more
value [job_item] ?

stLinkCriteria = "[job_no]=" & "'" & Me![job_no] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Thanks.
Joe
Click to expand...
Click to expand...
Click to expand...
 
Neil said:
Yes Joe,

You would need to change the strLinkCriteria as below.

stLinkCriteria = "[job_no]='" & Me![job_no] & "' And [job_item] = '" &
Me![job_item] & "'"

HTH,

Neil.

Joe said:
Actually, user will need to [job_no] & [job_item] at form A and it had a
button to open a subform.
and job_item is text.
so i want to pass the job_no & job_item to subform and display.

do i need to change the command to:
stLinkCriteria = "[job_no]=" & "'" & Me![job_no] & "' And [job_item] =
Click to expand...
'"
&
"'" & Me![job_item] & "'"


Neil said:
Hello Joe,

If the data in job_item is text, then change the line as follows:

stLinkCriteria = "[job_no]=" & "'" & Me![job_no] & "' And
Click to expand...
Click to expand...
[job_item]
=
'" & SomeValue & "'"

HTH,

Neil.

because my form is too crowded. so that I would like to move the subforms
to
a different page.

so i had make a command button to open a subform.

how can i change the following command line, so that i can pass one more
value [job_item] ?

stLinkCriteria = "[job_no]=" & "'" & Me![job_no] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Thanks.
Joe
Click to expand...
Click to expand...
Click to expand...
 
Joe,

The reason why you get that box is because Access cant find that field.
Check the field names. As for adding the new row, Access adds this so that
the user can enter a new record. If you do not want this then you will have
to set allow additions to be No and create another form just for inputting
data.

HTH,

Neil.

Joe said:
Thanks for your help.

I had used the code you provided. but it prompt out a box to ask me the
job_scode (previously called job_item).
http://www.efilehk.org/pp/jb_init2.jpg

And i had captured the screen of my application.......

Form [Job Initiation] included a subform [Job Details].
http://www.efilehk.org/pp/jb_init1.jpg

User need to input job no. and subcode. and there is a button for each job
[job no.+ subcode].

so i want to pass the job no. and subcode to Form [Job Transaction], but i
am not success to pass the job_scode.
http://www.efilehk.org/pp/jb_init3.jpg

Besides, when we addd/edit a record, Access will automatically add a row at
the bottom and had a [*] on left hand side.
Can i disable this features?
http://www.efilehk.org/pp/jb_init4.jpg

thanks !
Joe



Neil said:
Yes Joe,

You would need to change the strLinkCriteria as below.

stLinkCriteria = "[job_no]='" & Me![job_no] & "' And [job_item] = '" &
Me![job_item] & "'"

HTH,

Neil.

Joe said:
Actually, user will need to [job_no] & [job_item] at form A and it had a
button to open a subform.
and job_item is text.
so i want to pass the job_no & job_item to subform and display.

do i need to change the command to:
stLinkCriteria = "[job_no]=" & "'" & Me![job_no] & "' And [job_item] =
Click to expand...
'"
&
"'" & Me![job_item] & "'"


"Neil" <neil@_NoSPAM_haywood2k3.freeserve_NoJUNK_.co.uk> ¦b¶l¥ó
¤¤¼¶¼g...
Hello Joe,

If the data in job_item is text, then change the line as follows:

stLinkCriteria = "[job_no]=" & "'" & Me![job_no] & "' And
Click to expand...
[job_item]
=
'" & SomeValue & "'"

HTH,

Neil.

because my form is too crowded. so that I would like to move the
subforms
to
a different page.

so i had make a command button to open a subform.

how can i change the following command line, so that i can pass
Click to expand...
one
more
value [job_item] ?

stLinkCriteria = "[job_no]=" & "'" & Me![job_no] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Thanks.
Joe
Click to expand...
Click to expand...
Click to expand...
 
Back
Top