Help with developing database to be searched and updated

[radarman]

Hello everybody,

I'm in the process of learning Access and I'm running into a few problems. I was hoping somebody could help explain how I could accomplish this project.

I've created a table and an input form where the user inputs a date, a part number, and the person who first inspects the part. I now need someway to have other users be able to search for a specific part within the database, and then change the field to show they are now the person in possession of the part. However, I would like something like a nested table within the main database showing a history of who the part has been with.



So far, I believe the proper method would have something to do with a query. However, whenever I try to make a query, I can't input a part number to show just that part number, not the entire sheet.

I really hope someone can help me out with this.

Thanks,
radarman

[rpeare]

The easiest way to do this is to put a prompt in your criteria.

for instance

in the criteria section of your PARTNUMBER put in

[Enter the Part Number]

When you run the query a little pop up will appear asking you for the part number, just type that in and voila all records will relate to the item you typed in.

[radarman]

rpeare-

Thank you so much, that solution was perfect.
No i just need to find a way to nest a combo box or table within a cell and I'll be sitting pretty.

Thanks,
radarman

[rpeare]

I have no idea what you mean by this, you can't store a table in a single field in an access database and I can think of no reason why you'd want to. If you describe what you're trying to do it may be more helpful.

[radarman]

The idea is to be able to do a search by part number and once it comes up, be able to change the location of it (inspection, inventoy, manufacturing floor, etc.) However, I'd still like an option to click on the cell with the location to have some sort of drop down box showing where the part has been.

So for example, say a shaft is shipped to us. We take the shaft and send it to inspection. So the first record says in order of date received, part number, then location: 7/19/2011 12345 Inspection.
After inspection, it is sent to inventory. So I need the record to now read: 7/19/2011 12345 Inventory. And a day or two later, it is sent to the manufacturing floor. Therefore the record now would read: 7/19/2011 12345 Manufacturing.

Now say I'm doing a check to make sure a part did in fact go to inspection.
I would run my query, type in the part number 12345, and retrieve the record stating 7/19/2011 12345 Manufacturing. What I'd like is someway to click on the cell containing manufacturing, and have a drop down box say, in order from top to bottom, Manufacturing, Inventory, Inspection.

Is this possible?

Thanks
Radarman