I have built an entire database for our manufacturing plant. For the last stage of my program, I would like to be able to open a specific dxf or dwg file that corresponds to the part number in the form. How would I go about doing this? I have figured out how to open the program through a macro, but is there any way to open the program with specific file for each part number? This has proven to be quite a challenge. This is the last step to making the db completely funtional, but, also the most important. Thanks for your help.

You can try application.followhyperlink "myfilename". As long as there is a program registered on the computer so that it knows what to do with type of file you specify in myfilename, it should open that program and the specified file in that program.

That is incredible. It totally worked the way I needed it to. One last question. Is there a way to somehow do it a query, where if you click a button it will open the drawing file that corresponds to a part number? The drawing files are all named by the part number in the database. Can I somehow filter it so that only one drawing opens to the corresponding part number? Thanks for your help.

I am not sure I understand the question. Datasheets that contain query results are not for the consumption of the users. Users should be seeing the query results in a form (or report, but reports are not interactive, so let us not go there right now). On the form, you can add a command button next to each record and have code behind the command button that opens the drawing corresponding to the part number in that record.

How would I go about doing that. Filtering it to only open the current part number's drawing?

It depends on how the form is setup. If you set it up using the wizard to filter by form so that you can enter a part ID and the form pulls up the part details, you can add a command button on the form that would then have code on its onclick() event to open the file corresponding to that part (the name of the file can be part of that part's record in the database or if you have a specific naming convention, you can construct the file name in code).