 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008Open form to a specific record
Hi all, I am a newbie to Access so please go easy on me, and if you reply, please include every detail. :) I have one table consisting of info on various screw information (size, how many in stock, etc.) Very basic. My boss wanted to be able to search for a range of sizes, so I made a parameter query that looks like this: Between [first screw size here] and [second screw size here] That worked fine. I then created a split form using this query as the control. My boss would like to be able to edit info on this resulting form but I cannot edit on this form. Is there a way to edit on this form? If not, is there a way where I can click on the part number (my field for this is named Insert Model Number) that is shown on this resulting form, and have it take me to a form I already have (named Inserts) which is basically my "data entry" form for these items? I've tried using the macro wizard and while I can get it to open my Inserts form, I want it to go that the specific record that I am currently looking at so I can edit it. Thanks!! Carrie If your table or query are not editable, your form won't be. Check to see if the table and query have the arrow and asterisk at the bootom and will allow you to add records. If not, your form won't allow edits either. As far as searching your form, put a combo box on your form. Use the combo box wizard to do this for you and select size as the source of the combo. Right click on the combo and select properties. In properties, there will be one property called events. Go to events and select the afterupdate event. To the right of that event will be a button. Click that button and start code builder. In the code builder, type: Me.filter = "[size] = """ & me.combo# & """" Me.filteron = true The combo number (like combo12) will show when you start the code builder. This will allow you to search your form on screw size. > Hi all, > [quoted text clipped - 28 lines] > > Carrie On May 28, 2:33 pm, Golfinray <Golfin...@discussions.microsoft.com> wrote: > If your table or query are not editable, your form won't be. Check to see if > the table and query have the arrow and asterisk at the bootom and will allow [quoted text clipped - 44 lines] > > - Show quoted text - Hi - thank you for the reply. My table and form are editable - I can add, edit and delete records. Are you saying I should not be using the parameter query then? I will try your combo box idea and see how that works. Thanks so much! Carrie Hi, Sorry to post again. I need to be able to search a range of sizes like (from .05 to 6) for example. How would I do that? thanks! Carrie If you have the sizes listed in the table, the little combo box should give it to you. When you go into the combo box wizard it will ask you what table and what field will be the source of your combo. Tell it the table where your size is found, then the name of the field (column) where size is found. It will ask you for those. Once the combo is built, then use the little code I gave you. Put in the name of the field where the size is located (like tbl_0size) in the brackets. Then put the combo# (you will see that when you go to code builder) in where I put combo#. It should work then. If not, post back. > Hi, > [quoted text clipped - 5 lines] > thanks! > Carrie BTW, if you don't have those sizes in your table, you are probably going to need to add them. I though from your original post you may already have those there. If not, post back and we'll figure out another way. Ray > Hi, > [quoted text clipped - 5 lines] > thanks! > Carrie Hi Golfinray, I am so sorry I am such a pest with this. In my database, I only have one table total. Do I need a separate table that will hold the screw sizes? Right now I just have the one table with a field for screw sizes and we were just going to type them in. Then my boss said it would be great if we could search by screw size and come up with results and then be able to actually go to that part number that utilized that scew size and be able to make editions if needed. He also wanted to be able to search by other variables (we have other fields that show angle, thickness, etc.). Unfortunately I dont work with the production department (who will be the ones using this database) so some of it has been confusing for me. I think they basically want to keep track of these screws, the sizes and other variables of it, the material it was made from, and what project we ended up using it on. Is there a way I could email my DB to you? I may very well have the entire thing set up incorrectly. Which would be icky, but I'd rather know now than later. :) thanks! Carrie |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.