Form/Subform

[Srowe]

I have adapted an existing search form to meet my needs which utilizes the
gcriteria that you mentioned.

The search form enables the user to search for a person utilizing multiple
criteria to narrow down the search. It is opened from a button on the subject
detail form.

I made the changes you recommended but now when I enter a new name and say
yes to adding the new data it takes me to the subject details main input
form..that's good. The form had data from the subject table before but now
it seems to be gone.

My search form is based on the subject details form. I know that there is
data there but it won't recall it when I put my search criteria in. The
records indicate "1 of 1" but do not list anyone. There is also a button to
display all subjects when I hit that button it does the same thing.

It seems that the subject table is not populated or the subject detail form
is not populating from the right table. However when I go to add a subject to
the subjectcomplaints subform the population of subjects is there.

Very confused right now.

Scott

 

[Dirk Goldgar]

I have adapted an existing search form to meet my needs which utilizes the
gcriteria that you mentioned.

The search form enables the user to search for a person utilizing multiple
criteria to narrow down the search. It is opened from a button on the
subject
detail form.

I made the changes you recommended but now when I enter a new name and say
yes to adding the new data it takes me to the subject details main input
form..that's good. The form had data from the subject table before but
now
it seems to be gone.

My search form is based on the subject details form. I know that there is
data there but it won't recall it when I put my search criteria in. The
records indicate "1 of 1" but do not list anyone. There is also a button
to
display all subjects when I hit that button it does the same thing.

It seems that the subject table is not populated or the subject detail
form
is not populating from the right table. However when I go to add a subject
to
the subjectcomplaints subform the population of subjects is there.

Very confused right now.

The code in the NotInList event explicitly opens the form to add new records
*only*. Your original code was:

My suggested revision, using more up-to-date constants, was:

That doesn't change the meaning of the statement, though. The constants
A_ADD and acFormAdd both say to open the form in data entry mode, meaning
that no existing records are to be displayed -- only new records can be
added. That makes sense if the form is being opened for the sole purpose of
adding a new Subject. I assumed that was what you wanted, since that's what
your original code said to do.

If you don't want that, it's possible to open the form in normal mode;
however, opening in data entry mode seems appropriate to me in this case.

 

[Srowe]

Yes you are very right. And it makes perfect sense. In fact that was going
to be my next question is how do I get the entry form to be blank when I want
to add somebody...problem solved.

I will come up with another way of searching for somebody and displaying the
number of incidents they have been involved with.

Your help has been much appreciated.

Scott