|
-
November 2nd, 1999, 01:37 PM
#1
nested queries/ordinal position
I have four tables in a nested query sql statement. The common field in all these tables is the permit
number. When I try to display the value of the permit in a richtextbox for a particular record,
I get an error of "Item not found in this collection. The help information says the the field is found
in more than one table and that I must reference the display command by the field's ordinal position
in the nested query.
My statement looks like this:
With RichTextBox1
.SelText = vbCrLf & per1!permit
end With
What should the correct syntax be in order to display the permit number for the record?
-
November 3rd, 1999, 02:46 AM
#2
Re: nested queries/ordinal position
try
.SelText = yourRecordSetVariable.Fields(NumericIndexOfField)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|