Something needs to release the previous request

  • Thread starter Thread starter Anne
  • Start date Start date
A

Anne

I have created a form from on the users request, which lists all jobs, by
jobNumber, jobName, Contractor, Contact, ect. She wants to look at the list
and be able to sort by any field she chooses. That part works, she can sort
any field, and find the data that she is looking for.
I created an event, that when she finds what she is looking for, she can
click a button with a link field that takes her to the jobs form, which
displays the detail of the job she has selected. Up to this point everything
works.

Her selection displays the job she selected. So after she is done what she
wants to do with the job that she found, no other jobs, that are normally
available from the combo box, can be accessed, because somehow I locked the
data to just display that one job she was asking for.

How would I make a the other data available again, perhaps with a command
botton?
Anne
 
Anne said:
I have created a form from on the users request, which lists all jobs, by
jobNumber, jobName, Contractor, Contact, ect. She wants to look at the list
and be able to sort by any field she chooses. That part works, she can sort
any field, and find the data that she is looking for.
I created an event, that when she finds what she is looking for, she can
click a button with a link field that takes her to the jobs form, which
displays the detail of the job she has selected. Up to this point everything
works.

Her selection displays the job she selected. So after she is done what she
wants to do with the job that she found, no other jobs, that are normally
available from the combo box, can be accessed, because somehow I locked the
data to just display that one job she was asking for.

How would I make a the other data available again, perhaps with a command
botton?
Click to expand...


Can't she just close the Jobs form? This should take her
back to the request form where she can select a different
job to view.
 
The FrmJobs is the main form. The Jobslist form is actually accessed from a
command button from FrmJobs and she wants to use it for searches. Of course,
I could take the "go to that job" out on the Jobslist form and have her
close it and then select the jobs from the combo. But it would be nice to be
able to use it like this.
Anne
 
Seems a little backwards to me, but that's neither here nor
there ;-)

How is the Jobs form filtered?

If its record source query uses a parameter to the search
form, then just requery the jobs form:

Forms!FrmJobs.Requery
Forms!FrmJobs.SetFocus

If the jobs form is not filtered, then you can (usually?)
use its Filter property to restrict it to the desired
record:

Forms!FrmJobs.Filter = "JobNumber = " & Me.txtJobNum
Forms!FrmJobs.FilterOn = True
Forms!FrmJobs.SetFocus
 
You pointed me in the right direction. Indeed a filter was put on FrmJobs.
So I added a command button "reselect All jobs" and used your sample below
making the filter on = false. That made all jobs available again.
Thank you,
Anne


Marshall Barton said:
Seems a little backwards to me, but that's neither here nor
there ;-)

How is the Jobs form filtered?

If its record source query uses a parameter to the search
form, then just requery the jobs form:

Forms!FrmJobs.Requery
Forms!FrmJobs.SetFocus

If the jobs form is not filtered, then you can (usually?)
use its Filter property to restrict it to the desired
record:

Forms!FrmJobs.Filter = "JobNumber = " & Me.txtJobNum
Forms!FrmJobs.FilterOn = True
Forms!FrmJobs.SetFocus
--
Marsh
MVP [MS Access]


The FrmJobs is the main form. The Jobslist form is actually accessed from a
command button from FrmJobs and she wants to use it for searches. Of course,
I could take the "go to that job" out on the Jobslist form and have her
close it and then select the jobs from the combo. But it would be nice to be
able to use it like this.
locked
the
Click to expand...
Click to expand...
 
Back
Top