Nope, the form was loaded all right :-) The text fields were on the top part of the form, and the spreadsheet object was in the bottom part.
It started working once I deleted the spreadsheet and replaced it with a sub-form containing a table. The table is linked to the form field.
Interestingly, I found if I had done a separate table generated by a query, suddenly the format
WHERE MyTable.LastNam e = [Forms]![MyForm]![LastName]...
ozTinker
Last Activity: Jun 21 '07, 04:51 PM
Joined: Jun 18 '07
Location:
-
Just to give you some perspective, what I found was that all these ideas were good but none of them worked in the Spreadsheet object, most likely because the ActiveX control does not fully implement the VBA conventions.
If I opened a datasheet and had a form open at the same time, then yes the syntax was correct for reading the form control and modifying the SQL query based on that. Wroked beautifully in fact.
It would...Leave a comment:
-
Thank you all for your responses. I looked at the areas you suggested and while this surely has me on the right track, my form still needs some work:
- First I verified that the field name was correct; it is "LastName", same as the table column.
- The text field and the spreadsheet object are both part of the same form.
- Then I tried the statement:
WHERE ("My_Table.Last Name=...Leave a comment:
-
Referencing form value from within a query
I'm sure this shouldn't be too difficult, but I lack familiarity with the MS object model.
Suppose I have a table "Purchase_Order s" and a form "TEMP" which I am using to look up a customer's orders. The form has a text field named LastName for typing in new orders, but first let's look at the previous orders. Elsewhere on the form is a Office Web Components Spreadsheet version 11.0, which will run a query and show...
No activity results to display
Leave a comment: