Combo Box auto fill and update table

[memmons]

I am sure this is a super simple question. I am new to access and have created a database with multiple tables to record information about specific vendors. Each vendor has an assigned vendor number that I want to follow them to each table. I created a form associated with the contracts table, it has a combo box which looks a the vendor table and when you select the vendor you want it auto populates the vendor number text box. Once you have finished filling in the rest of the form and move to the next record it adds everything to the table except the vendor number. The vendor number text box control source is set to =[cboVendor].[column](2). What am I missing here is there some coding that I need to do? Thanks in advance for any help - Marc

[pbaldy]

Does this help?

BaldyWeb - Autofill

[memmons]

Thanks!! That solved my issue

[pbaldy]

Happy to help, and welcome to the site by the way!

[ssanfu]

The vendor number text box control source is set to =[cboVendor].[column](2). What am I missing here is there some coding that I need to do?

In order for a control to save a value to a field in a table, the control must be bound to the field. You have an unbound text box because the control source is "=[cboVendor].[column](2)"; it should be something like VendorID_FK (or whatever your field name is).

You could use the after update event of the vendor combo box to enter the vendor ID, or the form Before update event.
In either case, the line would look like:

Me.VendorID_FK =[cboVendor].[column](2)

(change VendorID_FK to your field name)


my $0.02.....