Prev: Generate Styles list with Definitions for a Template
Next: It stopped
From: bryan on 2 Jul 2008 15:32
I have used the "calc on exit" to populate a reference.
the reference being referred to the bookmark
To create a reference:
Ctrl + 9 then type within the brackets ref textxx \* charformat
then F9

Once you tab out of field textxx it will populate the ref mark

Bryan

"jwhittrn" wrote:

> Actually, I was looking for the simple non VB button, which I did find (I
> knew it was there I just was using the wrong toolbar) now i need to know how
> to use the "calculate on exit" I believe it is to auto populate another
> field..
>
> thanks for your help!
>
> "Karl E. Peterson" wrote:
>
> > jwhittrn wrote:
> > > at this point I just need to know how to populate my pick list.
> >
> > Not sure if you're wondering how to trigger the fill, which would be something like
> > this...
> >
> > Private Sub Document_New()
> > Call FillList
> > End Sub
> >
> > Private Sub Document_Open()
> > Call FillList
> > End Sub
> >
> > Or the actual mechanics of the fill, for example...
> >
> > Private Sub FillList()
> > Dim db As Database
> > Dim rs As Recordset
> > Dim sql As String
> >
> > ' TheDatabase is defined globally in MBuildLabels
> > Set db = DBEngine.Workspaces(0).OpenDatabase(TheDatabase)
> > Set rs = db.OpenRecordset("SELECT Lists.* FROM Lists;", dbOpenSnapshot,
> > dbReadOnly)
> >
> > With cboLists
> > Do While Not rs.EOF
> > .AddItem CStr(rs!ListID) & " - " & rs!ListName
> > rs.MoveNext
> > Loop
> > .ListIndex = -1
> > End With
> > End Sub
> >
> > --
> > ..NET: It's About Trust!
> > http://vfred.mvps.org
> >
> >
> >
 | 
Pages: 1
Prev: Generate Styles list with Definitions for a Template
Next: It stopped