MS Access: Make a form only see certain records

With the help of EE the form “frmTools” is finally working it sees the three tables as I need it to.

I was hoping to use the SQL code from form “frmToolsLookUpDimensional” to make it so the form “frmTools’ would only see Dimensional tools.

I have looked for a “Row Source” in the data tab of the properties box but don’t see one. Why is this “Row Source” not in this form?

Here is the SQL code:

SELECT tblTools.Tool_PK, tblTools.ToolName, tblTools.TypeOfDevice, tblTools.Location, tblTools.Brand, tblTools.[Code_#], tblTools.[Model_#], tblTools.[Serial_#], tblTools.InUse, tblTools.Inventory, tblTools.OutOfService FROM tblTools WHERE (((tblTools.TypeOfDevice)="Dimensional"));

This could also be used in the field “TypeOfDevice” but I don’t see a Row Source on the Data Tab in the properties box.

Any idea on how to do this??



I have six other tables to do this with and I almost have a working example to use on the other tables.

Measuring-Instruments-5-03-11Rev.mdb
James CoatsComputer Info. Sys. StudentAsked:
Who is Participating?
 
Jeffrey CoachmanMIS LiasonCommented:
<Both of those of those options are not in the properties dialog box in that form.>
That's odd...

I can see the record sources of each form/subform quite clearly.

Open the form in design View
Press the F4 function key
Click the "All" Tab
Scroll all the way to the top.

To see the record source of the subforms simply click the small gray box in the upper left hand side:








 main form sub form
0
 
Rey Obrero (Capricorn1)Commented:
Forms/subforms uses Record Source not Row Source (for combo/list box control)
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Row Source or RecordSource ?

Row Source applies to Combo and List boxes ...
RecordSource applies to a Form.

mx
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
James CoatsComputer Info. Sys. StudentAuthor Commented:
Both of those of those options are not in the properties dialog box in that form. Where is Record Source in that form How do you apply the SQL code when those options are not there?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
see image
Capture1.gif
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Uploaded version has your SQL for the RecordSource on frmTools.

mx
0
 
Jeffrey CoachmanMIS LiasonCommented:
<No points wanted for my posts>
0
 
Rey Obrero (Capricorn1)Commented:
:-0
0
 
Jeffrey CoachmanMIS LiasonCommented:
Thanks, but I only helped with finding the Recordsource.

AFAICT, MX actually posted a solution to your question directly...
<Make a form only see certain records>
...where as I did not...
0
 
James CoatsComputer Info. Sys. StudentAuthor Commented:
Cap,

Sorry I forgot about you... didn't mean too. boaq2000 would you share some of your points with capricorn1? All of you helped me.
0
 
James CoatsComputer Info. Sys. StudentAuthor Commented:
Now I can't see the other two forms "subfrmInspectionChecks" or "subfrmDimensionVerification" I need to be able to enter data in these two related tables. The form now sees just the "Dimensional" tools but not the related tables which need to be able to recieve data concerning the tool. Can I ask a related question and give more points or should I ask a new question??

I am going to try to reconnect the tables to the form first see if I can fix this.
0
 
James CoatsComputer Info. Sys. StudentAuthor Commented:
I don't know what happened but now the form sees the other two forms. I didn't change anything. I don't know why it wasn't working just a few minutes ago.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Please note that as of late, there have been a increased number of UFO sightings World wide ...

mx
0
 
James CoatsComputer Info. Sys. StudentAuthor Commented:
Yea, I am taking a break now to do some analog work I'm seeing pixels everywhere...
0
 
Jeffrey CoachmanMIS LiasonCommented:
FWIW,

I really don't care how the points are assigned...
A three way split would be fine with me...
But you could also exclude my post and just give points to MX and cap...


;-)

Jeff
0
 
James CoatsComputer Info. Sys. StudentAuthor Commented:
Jeff,

Your post was very informative to me as I did not know to right click on that little black square that is why I gave you the most points. You can give up some points to cap. You can choose how many. How to we do this?
0
 
Jeffrey CoachmanMIS LiasonCommented:
Just click the "Request Attention" link and explain the points distribution you would like...

;-)

Jeff
0
 
James CoatsComputer Info. Sys. StudentAuthor Commented:
Thanks guys,

You have really made a difference and I am learning this program too!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.