I’m in the middle of my test week with Panorama and I think I’m beginning to get a feel for things.
For example, I originally set up different databases with categories of information that would then be part of a relational group, but I found that for everything to be accessible each database would have to be open at all times (is this right?). This led me to simplify matters by combining all three databases into one called “Reference Information”. To identify each category of information, I affixed a letter prefix to each record index number, i.e., “H” for hotels, “R” for restaurants, etc.
I now have different forms to display each category of information, but only the appropriate category should appear when the form is called up—only hotel information in the “Hotels” form, for example. Selecting only records whose index number begins with “H” is the logical way to go, but only the data sheet has a search panel not forms.
Thus, I think I have to use a procedure to select the appropriate records. I’ve used the Procedure Recorder while in the data sheet to successfully select the records. But then I copied the procedure from the Recorder into the Form Event Procedure so this will be used whenever the form is opened—and I’m getting a syntax error.
Is everyone still with me? (Apologies for the length of this post.)
First, is combining databases and creating different forms an efficient way to go?
Second, is the Form Event Procedure the right tool to use for what I want to do?
Third, if it is, which statement is necessary to make the Form Event Procedure happy?
Much thanks for any guidance.