Text Box Control Source Issue

[timbit6002]

Hey all,

I'm new to access and new to this forum. I have only been using the front end of access, and dont know much about VBA coding and whatnot. So far I have been able to trundle along, but today I have encountered a problem. I have a form where users input data into a table (table1), which has some text boxes and some combo boxes. One of the combo boxes (which pulls its data from a different table, table2), when updated, automatically fills two of the text boxes. I have managed to get one of the text boxes to input data into table1, but I cant get that second textbox to input data into table1, even though it appears in the text box.

Any ideas would be great.

Currently the text box's control source is =[Combo19].[column](3)
What do I need to change to get it to input it into a certain column in table1?

[pbaldy]

This should help:

BaldyWeb - Autofill

[timbit6002]

So in my case:
Me.TextboxName = Me.ComboName.Column(2)

what would I put in the front when referencing a table?
if my table was 'Main' and column named 'run':

Main.[run] = Me.[Combo19].[column](3)

thanks!

[pbaldy]

No, the first part would simply be the name of the textbox. From the link:

In the textbox, instead of the formula as the control source, you'd list the field in the Orders table where you wanted the phone number saved.

So in your case the control source of that textbox would be

Run

Assuming of course that the form is bound to the "Main" table.

[timbit6002]

Thanks a ton pbaldy! Great help!

[pbaldy]

Happy to help, and welcome to the site!

[pbaldy]

From your PM:

I know I said my access database worked, but I keep getting errors on the after update input. I have changed the text box control source to the table column I want to input it in, and placed Me.Run=Me.Combo19.column(3) in the property sheet. It just doesnt want to run, telling me that access cannot find 'Me.'

That is VBA code and won't work in the properties sheet. It goes here:

http://www.baldyweb.com/FirstVBA.htm

[timbit6002]

Thanks for the final time!

worked like a charm

[pbaldy]

No problemo!