Auto Fill a Form

[one3nine0]

I have two tables Customer and Notes

Customer Table has: CustomerID, Customer Name

Notes Table has: NoteID, Customer ID, Notes

There is already a 1 to many relationship based on CustomerID

I want to create a form that adds entries into the Notes table where the user can enter in the CustomerID and the Customer name will auto populate.

I originally tried to do this by having the Customer ID in the form be a combo box selecting from the customer table.
I then changed the control source of the Customer Name field to comboboxname.column(2)

This auto filled the form correctly, but it would not save that data into the Notes table.

What am I doing wrong?

 

[alansidman]

If you have the information in the Customer Table, why would you need it in the Notes table? If you need to extract the information, you can write a query since the tables are linked.

 

[one3nine0]

Yes, but when the user is entering the notes into the form, it would be nice to have validation that the customer ID used matches with the correct name.

IE I could type in customer ID 115 and "Joe Smith" fills the customer name, but i realize i mis-typed and meant to put in 1115 for "Jane Doe"

Also looking to expand my access skills as I know auto fill is possible, just not sure why this is not working and updating my table

 

[one3nine0]

Got it. Used an Event based macro to populate bound text boxes