Recent content by VTXscooter

I have started over and am still having trouble. The report references a mastery inventory table that has a lookup field that referencers several locations. When I run the report I get the ID number of the location as oppossed to the Name of the location. Is there some sort of filter in the...

On one of my reports I have a site location that comes up as a ID number instead of the info in SITE_LOCATION. Is there a filter to change the ID number to the Wording? Thanks, Joe

Thanks! That worked great. Joe

Is there a way to change all the fonts sizes with one click? I used the wizard to build a report and now I am stuck with the standard fonts. Thanks, Joe

Mine is a Retro, looks like a fifties style. I have had a 62 and a 67 HD in years past. Take care, Joe

Thanks, got it! Joe

WOW, that was fast and it worked! Thanks! Now I need to figure out how to add a button for a new record and have it save the old one. Seems to me I used the toolbox before to do this. Ken, what kind of bike is that in your avatar? I have a VTX1800R.....

I would like to hide the record number scrolling feature in my forms. How is this done? I have searched through the properties of the form but am missing something I suppose. Thanks, Joe

Thanks, I got it fixed with SQL Joe Project drop down SELECT TblProject.ID, TblProject.Project FROM TblProject; Location drop down SELECT TblLocation.Location, TblLocation.Project FROM TblLocation WHERE (((TblLocation.Project)=Forms!FrmReviewRecommendations!Project)); And I third one...

Thank You.

Mark, I actually still have a problem. When I make a choice in the first drop down and then a choice in the second drop down, If I go back to the first drop down and make a change it wont let me choose the correct data in the second. I will attach the file. Thanks, Joe I would also like to have...

I think it is working well now with all of your sugesstions. One thing I noticed was if I make a choice in the first drop down it allows me the correct choices in the second. If I go back to the first as if I had made the wrong choice it then keeps the second from changing to the correct data...

Mark, THANK YOU..... That made a huge difference! I treally appreciate it! Joe Why is is when I open my form the next time it has data in it and wont allow me to get back to my defaults? I want this data stored in a particular table. Also would I follow the same steps for the next teo drop...

I have made allot of progress on this reading the forums and so examples. The problem I am having now is my first and second drop down boxes have a number in them instead of descriptions. My second drop down box has only choices 1-6 when in fact there should be 12 choices. My Project drop...

The SQL is the part I dont understand. In the from I have a project drop down field and then a location field. When I choose one of two projects I only want the locations for that project to show up in the second drop down field I have a location table with all of the locations in it plus a...