Hello Cetin -

I am probably jumping the gun with this message. Matter of fact, I know I am. However, I couldn't resist sending another post, because I learn something new each time. I logged on this morning and retrieved your last message. I implemented the code real quick at my development computer (home) but had to get to work, so time was short. Unfortunately I am unable to work all day on my computer projects because my full time job will not allow it. I do the database development work for a computer company "on the side". I hope to be with them full-time in a years time, but for the time being I only have my nights to develop. Needless to say, that is frustrating, b/c as you probably know, these development projects can be all consuming.

That is probably more information that you bargained for, huh?!!

The reason I say I may be jumping the gun with this message, is that I didn't have the opportunity to spend a lot of time working with the code to get it to work this morning.

Currently, I have the following code in the INIT() of my offices form.

lparamters tnId
select offices
set order to tag id
set key to tnId
_____________________________

In the click() event of my cmd button of my search form, I have placed:

with thisform.cmbofficetitle_search
m.myofficeId = val(.list(.listindex,2))
endwith
if !empty(m.myofficeId)
do form offices with m.myofficeId
endif
________________________________________

I selected values for each of my 6 combo boxes to select an office and clicked my cmd button to fire my offices form and received an error message>

Variable id is not found

**My confusion, or lack of understanding , revolves around the relation, or link, between the two pieces of code. My untrained eye doesn't see the relation. It would seem "to me" that the code in the init() would need to have some sort of tie to the click() code. Maybe it does with the "tag id" piece of code and I have something else fundamentally wrong with my development. I don't understand why the variable m.myofficeId is not placed in the init() of the office form. Also, I don't understand why a WITH or IN statement is not placed in the code to refer to the office_search form.

** I didn't alter the datasession to private, which I will try later on tonight.

Like I said before, please forgive me for posting this message w/o spending adequate time trying to get the code to work. I just have this on my mind and thought I would spend a few moments writing a post to get your insight, before I went back and tackled the job at hand.

If you have any further thoughts as to why I am receiving the "variable id is not found", I would appreciate your input.

Thanks

Jason