Fill a field with a variable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A very simple problem, I'n trying to fill a field (my_field) with a value.
When I write
my_field = 1
it is working fine.
But when I write
my_var = [forms]![someform]![somefield]
my_field = my_var
it is not working.
In the debugger the variable my_var is filled with a number,
but it is not working. It is only working, when doing
me.dirty
me.requery
after filling my_field.

Any hint?
 
perhaps you could set the form, then just reference the field directly?


like,

set myForm = Form_frmMyForm

my_field = myForm.somefield.value

? I am not too good with all this form stuff, but i think that is how I
would do it.
 
Back
Top