Setting a value from a variable used in VB code into a field on an Access form

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

I have created some code for a form in Access using Visual Basic event
procedure. This code includes a variable that contains a value that I
want to place in a field on the form. The VB code defines and calls a
..DLL. All of that works fine. I just need to know how to place that
value in the field on my form, using the Visual Basic code. Do I use
the Set command or something else?
 
Eric,

The command line is:
Forms("FormName").Controls("ControlName") = variable

where of course you will have to change FormName, ControlName and variable
to the actual form, control and variable names.

HTH,
Nikos
 
Nikos,

Thank you very much! That's just the code I was looking for. It worked very well.

Eric
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Manipulating field values in a form record 3
I need a Form button to open and pass two variable values to a re 2
Struggling to set the value of a field in a form automatically 1
Assigning a value to a field based on other fields value 8
Data entry to table from a form 1
How do I find all uses of a field in Access (Queries, Form/Report SQLs, VB, etc) ? 2
Adding a value to a field that is not on a form 1
how to set the Default Value of a Control Box to a Lookup Table 0

Back
Top