Access Noobie Issues

[Misterpokey]

Good Day,



I am working on an idea I proposed for asset tracking for my job. I have already accomplished half of my goal but am struggling with the other half.

The idea is that I have one form that creates and inserts an asset record into a To be Processed table. I created another form with a List Box with the records from the To be Processed table. This form is for the Processor to select the record from the list box and click a sort button and the record would be sorted into another table based on the department that the asset is assigned to.

The initial form has the user input a serial number, asset tag number, asset type, DEPARTMENT, and date deployed. The button described above should read the department column and sort the record into that departments table and delete the record from the To be Processed table. I have already created the other department tables.

I have some programming experience but I just don't know VBA syntax well enough to do this on my own. Ill be perfectly honest I am in over my head so any help would be appreciated.

Thanks in advance!

[isladogs]

It sounds like a structural error. If you have separate tables for each department you are making a mistake.
You should have one table to handle records for each department with a department field.

[Misterpokey]

Gotcha so for what I am doing it should basically be 2 tables. One being the To Be Processed, the other being something like Processed. Then have a report function filtered by department. That's what you're recommending?

[pbaldy]

Colin is probably at the pub.

I don't think you should even have those 2 tables. I'd have a single table with a "Processed" field. It could be a Yes/No field or whatever has meaning to you. Perhaps a text/number field that contains a value that signifies what stage an item is in, if it could be more than those 2.

[isladogs]

Actually I was asleep .... but I agree 100% with what Paul wrote.

[Misterpokey]

Thanks guys I appreciate the help!