I have a bound form that the user can 1) enter in the id code or 2) click a button to execute a popup. When the popup button is used the value is returned to @WINDOW and QBFLIST.

I have a forward_event in the READ of the WINDOW to check if the record exists. If so, then I fill some list boxes with data from

hidden controls. This works fine for scenario 1.

If scenario 2 is used, then I am getting the message "FS100: Record nn does not exist" if it doesn't and the code in the read event does not get processed. Why?

If the record exists then it acts as if there is no data.

What should my database options be to correct this?

Bruce,

Is there a reason you are using QBFLIST? Unless you are selecting multiple keys this is not the easiest property to work with. Well, the property works fine, but regular events don't work the same way without extra work to manage them.

dbakke@srpcs.com

SRP Computer Solutions, Inc.

Don,

I usually use this and it has worked fine.

Why I'm getting that "FS100" message is unusual for me.

I would like to just process as if I entered in valid ID and

hit Tab. Normally when using QBFLIST that is what happens.

What are the other methods to return aa value from a popup to

the id control of a bound form and then have the form continue?

Bruce,

We just set the TEXT property of the key control(s) and then Send_Event(@Window, "READ").

dbakke@srpcs.com

SRP Computer Solutions, Inc.

Don,

So in the Click event for the popup button i put

Declare Function Popup

id=Popup(@window,'popupname')

.ID-]TEXT=id

Call Send_Event(@WINDOW,"READ")

Now, on a clear form I click the popup button and get "All key values empty"…

What is the tab order between the button and the prompt?

The Sprezzatura Group

World Leaders in all things RevSoft

Sprez,

I thought about that before and adjusted but got the same results.

I have tried a change and wanted to ask this.

If my form is bound to tableA. ID's are to be initials.

My popup button lists users ID's and Names from the TableU.

TableA's ID's will be the user inits (i.e. ID's).

If nothing is entered in the Form ID and the popup button is clicked

I want any result (i.e. the user id) from this to go into the forms id. Then the read should happen. If the selected id is not on TableA then I send_forward event in the window READ which I do a get_prop window, record. If the record is null I fill with default data hardcoded. If not null then continue on. filling in the next control, which is a symbolic name off TableU etc.

This works great if I key the id in and hit TAB/Enter. Its the popup

usage that seems to bypass the window read altogether and I get that "ID not on table" message and then the form is blank.

I can send the form if that would help.

TIA

Bruce,

What is the name of the edit line control for your key field? Bet it's not ID. It's the TEXT of the key control you want to set, not the ID property of the window.

- Oystein -

Bruce,

What is the name of the edit line control for your key field? Bet it's not ID. It's the TEXT of the key control you want to set, not the ID property of the window.

- Oystein -

Oy,

Id=Popup(@window,"",mypopup)

.ID-]TEXT=Id

bruce

Bruce,

So that's what it was. You could have found that out earlier if you'd used the Debugger (that Popup didn't return anything).

Sorry for misreading your code. I'm not too familiar with that dot and arrow syntax.

- Oystein -

Ummm, I'm not sure I follow you. Popup is returning the value.

It's that they value is not on the bound table that I get the message.

Normally in the past when I've done this I do not get the msg "XX is not on table"; it just assumes a new entry and continues processing and in my case I want it to do the code that that is in the READ event for the form because if the item is new them I build default data and display. If not new, read in the record and display.

Bruce

Bruce,

We should be chatting instead.

I thought I saw you had changed the Popup call from an erroneous

Popup( @Window, PopupName )

to a correct

Popup( @Window, "", PopupName )

and assumed that solved your problems.

Anyway. In your original posting you said you do Forward_Event and check if the record exists. Perhaps there's something wrong with that code. Can't you do the following instead?:

Key=Popup( … )

.ID-]TEXT=Key

Status=Send_Event( @Window, "READ" )

/* check if a record was read */

if Get_Property( @Window, "RECORD" ) then

. /* yes */

. …do stuff…

end

- Oystein -

Guys-

How about using Get_EventStatus and Set_EventStatus?

Might give an indication of what's going on…

Mike

View this thread on the forum...