Using DoCmd to set a value

Topic

New Reply

Access help files says that you can set value for a control by using DoCmd function, however it doesn’t tell me how? There is no SetValue object for VBA.

Thanks in advance!

Reply | Quote

Replies

Hi Brent,
I think the help files are a little misleading on this! They say that you use docmd to run actions in VBA, and that actions are such things as closing windows, opening forms and setting the value of controls. However, it goes on to say that there is no DoCmd method corresponding to setvalue. This shouldn’t really affect you as you can simply set the value of a control directly – for example, Me!txtTextBox1 = “Hello”
Hope that helps.

Reply | Quote

It worked perfectly! I really appreciate it.

Reply | Quote