At work, we have an access database that keeps track of our computer inventory. I created a form for easy entry of the computers, their hardware, and their installed software. We have more than 200 comuters in the table. I copied the "Entry Form", pasted it, and renamed the copy as "Edit Form". When we open this form, I'd like for it to prompt the user for the computer name. After entering the name, the computer and all of it's information will pull up in the form for editing (example: We installed more RAM into a computer and need to reflect this change in our inventory. I would pull up that computer name and change the amount of RAM to the new amount). I created a query with the prompt.
Here is the problem:
The original form "Entry Form" is linked to the "Entry Table". Since the new form "Edit Form", is a copy of "Entry Form", it too is linked to the "Entry Table". How can I change the link of "Edit Form" from "Entry Table" to the query I built?
What I've tried:
I opened "Edit Form" in design view, selected the "Computer Name" field, and selected the "ALL" tab. Under data source, I changed "Computer Name" to "=[Computer Query]![Computer Name]". When I open the form now, I still don't get the prompt. In addion, the computer name field displays "#Name?" instead of the actual computer name.
Is there a way to change the datasource from the table to the query? If not, I'll have to create a new form in design view and have it link to the query during the initial setup. I know this will work because I've done it. The problem there is that the form has MANY fields and I'm trying to prevent myself from having to recreate the layout of the original form.
Any and all information will be greatly appreciated.