Noob question about Query by Form

[iamrah]

Hi all, I'm pretty new to Access, but catch on quick. I have posted this question at another access forum, but have not received any input - maybe it's in the way the question was asked.

I have a developed a database to track patient ID, patient name, then several other fields of data such as therapies recieved, medications etc. The main form is used to input the data for each record.

The point I'm at now is the switchboard. I have created a command button that when pressed will open the main form at the first blank record for data entry on a new patient.

I want to add another command button that when pressed will open a pop-up/form/text field that will allow me to input a search criteria. The two criteria I would like to use are Patient ID or Patient Name. When the search criteria is entered, I would then like for the main form to appear at the record specified by the criteria for record editing.

Clear as mud? I'm pretty sure there's a fairly easy way to go about accomplishing this task, but I'm clueless. I have tried a couple of different routes, but wanted input from you guys about what would be the easiest way to address this.

Thanks in advance.
Frank

 

[gemma-the-husky]

there is a switchboard wizard in access. use that as you need to add loads of code behind the form, and the switchboard wizard does it all for you. after you have made the switchboard its then easy to modify the switchboard menus directly, as they are filled from a local table in the dbs

 

[iamrah]

Hi gemma,
Thanks for the quick reply. I love huskies, BTW.

I tried using the wizard when I first made the switchboard, but I'm not sure I went about it the usual way. I simply made a form using the form wizard, and call it my switchboard. The best I could do was to get the record to launch in datasheet mode.

I then made a query, and linked a command button on the switchboard to it. This route seems to be the easiest, but again the resulting display is in datasheet mode. I would like for the main form to open at the record selected by inputing the criteria on query.

Thanks again.

 

[iamrah]

I just realized I set up my switchboard wrong. I did it a second time using the wizared gemma suggested, but I am still having the same problem with the search button. That is, when I hit the button, and enter a search criteria, the resulting data opens in a datasheet view. I would like for the main form to open displaying the the record of the selected criteria.

Also, now, when I close the 'search' pop-up without entering a search criteria, I get an error alert "Action Failed". Is there a way to turn this off?

Thanks again.