Nobody answered this the first time, so I'm asking again...

[scottk]

I currently have a form "client information" with a subform "catagories." Of course, a client can be a member of several different catagories. One catagory in particular "Chapter Member" can have many different attributes to it. I have created a button that will open second form when pressed so that these attributes can be recorded.

What I would like to do is this: When someone presses the button to activate the second form, I would like for the subform catagories to be searched for the specific entry "Chapter Member." If the entry is found. The second form will be opened. If the entry is not found, it will be added and then the second form will be opened. So my question is, how can I accomplish this?

 

[Chris RR]

What's the table structure?

 

[scottk]

There are three tables involved here. I'll shorten up the descritpions just enough so you get an idea without having to have a whole bunch of meaningless details.


Client Info
___________

Client ID - Key
Name
Address
Office

Catagories
__________
Catagory ID - Key
Catagory Descrtiption

Link
____
Client ID - Key
Catagory ID - Key

The relationships are simple with the obvious fields related to each other.

The main form has the name and address information on it. The subform contains all the Catagory data.
The Office field would be on the second form that I want to open. The only catagory that has offices is the "Chapter Member" Catagory.