Cannot Access Selected Table?

[rclarke]

Hello everybody

Hope you are all well

I have a problem

I have a table of contacts

some are growers
Some are Hauliers
and some are both

on a form I have writen for accepting loads in to our company. On it are two combo boxes one for supplier and one for Haulier.

The first combo box has the select statement

Select org_scontacts from organisations where org_bgrower=.T.

I.E selects all the suppliers in the contacts table

The second combo box has the same select statement but where org_bhaulier=.T.

but when I run the form it says Cannot access selected table. When I click ok it displays only one combo box

what is going on or rather what am I doing wron

Any help would be greatly appreciated

Rachel

 

[ramani]

May be you have to include the PATH statement to locate the Organisers DBF. This shall be done at the beginning of the Main prg. ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com

 

[TomasDill]

Hi!

You require to use different name for the cursors used to store the result of the SELECT statements in the combobox. SELECT ... WHERE ... INTO CURSOR CursorName.

Instead of CursorName use the unique cursor name for the result set. Without this second query result overrides the result f the first query, thus it do not see it (Cannet select it).

Another reson of this error is that you closed the result set for cobobox, or just opened another data in the workarea occupied by the result set for combobox.

Vlad Grynchyshyn
vgryn@softserve.lviv.ua

http://www.softservecom.com

The professional level of programmer could be determined by level of stupidity of his/her bugs

 

[rclarke]

Thank you very much both of you are stars

 

[DEDMOD]

Thank you very much both of you are stars.

In which case, you might want to click the little thingee at the bottom of the useful message and vote for the person as 'tipster of the week'. I note that a lot of times people thank someone but ignore starring the message.

Dave Dardinger