K
Kevin
If your putting a value into a text box, the type variable
must be of the same type as the underlying recordsource
(table)field. If the field in the table is a text field,
the variable must be a string. If the field in the table
is a Long Integer, the variable must be a long, etc. If
the textbox is unbound, it won't matter. To set the
textbox field (I am assuming your doing this on a form)
you would do something like the following:
dim myVariable as (whatever type is appropriate)
myVariable=something
I am assuming you will be doing this from an event on a
field, command button, etc. on the form your working with)
to assign the variable to the field on the form...
Me!myfield=myVariable
I hope this helps! If you need more help, post back with
more information about what exactly your trying to do and
someone will help!
Kevin
must be of the same type as the underlying recordsource
(table)field. If the field in the table is a text field,
the variable must be a string. If the field in the table
is a Long Integer, the variable must be a long, etc. If
the textbox is unbound, it won't matter. To set the
textbox field (I am assuming your doing this on a form)
you would do something like the following:
dim myVariable as (whatever type is appropriate)
myVariable=something
I am assuming you will be doing this from an event on a
field, command button, etc. on the form your working with)
to assign the variable to the field on the form...
Me!myfield=myVariable
I hope this helps! If you need more help, post back with
more information about what exactly your trying to do and
someone will help!
Kevin