I'm a relative newbie to Access, working in 2003 and trying to build a very simple client database for my company. Here's the basic set-up I have so far:
-Clients Table contains all the relevant contact info for all clients. Name, address, email, contact person, etc.
-Orders Table contains each order the various clients have made, including dates, quantities, etc.
The Orders table contains a Client ID field that links it to the Clients table. The trouble is right now you have to open the Clients table and scroll through it to find the ClientID for each order, which is silly and time-consuming. I created a parameter query that returns the ClientID when you search any part of the client name, but I ran into trouble when I tried to embed it as a subform in the Order entry form. (In my ideal world, users would open a single form (with subforms, obviously) to look up a client's ID and enter their order info.) I want users to be able to re-enter the parameter if they mis-type something or have more than one order to enter in a sitting, but can't for the life of me figure out how to get the prompt window to re-open without closing the form entirely and reopening. Not actually sure if it's possible or not, so any solutions regarding entering new parameters without closing and reopening forms would be greatly appreciated.
I am not very familiar with VBA, but can figure it out if given simple and concise instructions.
Thanks!