> I have run across a most anoying problem. Here is the background:
> I have built a one-to-many form using a grid to display the records of
> the child. In the grid I only want to display 3 columns - so I set the
> columncount property to 3. Then I assigned the proper fields of the
> child to the grid's columns. However, when I run the form, the grid has
> more that three columns - it has a column for EVERY field in the child.
> Nothing I can do will make only the three columns I want appear.
> Any suggestions?
> Thanks, Erol
if you using multi-form and use 'Do Form' Version on create form.
I will suggest:
*Form.Activate
Select MYTable
Set Field to [NeedField1, NeedField2, NeedField3]
and change back to all field when deactivate the form!
* Form.Deactivate
Select MyTable
Set Field to
Note: That moment will tract there is only 3 fields in table.
so, if you want to use other fields on display, error occur.
THis is surely not expend too much.
Then, code:
Thisform.Grid1.ColumnCount = -1 && clean out all column.
Thisform.Grid1.Recordsource = [MyTable] && Recall the alias again
*** IF you use CreateObject() Version on Create form to use.
I will strongly recommend you DO NOT try this code,
else you need to waste more time but got more error on it!! ~~~>_<~~~
---------------------------------------------------------------------------
Qiantang River Arts & Furniture Ltd. - Computer Dept.
Just OK la (Terence)
URL: http://www.qiantang.com/
by