Struggling with saving autofill

[Surreall]

Hi all,

I have two tables, Customer Details and Jobsheet table

I have created a form that populates the jobsheet table. I used combobox to get the customerid from the customer table. And then in the other fields on the jobsheet form i use

=[Combo819].[column](4)

To get each column from the combobox.

Now when i save the form. The jobsheet table updates with the next jobsheet, but all of the autofill fields are empty in the table.



I have read up about afterupdate...and tried this

Private Sub Title_AfterUpdate()
Me.Title = Me.Combo819.Column(3)
End Sub

Where Title is the name of the text box where the autofill is. And Combo819 is the combo box (that has lots of columns). But the jobsheet table isnt updating. Is this cause the combo box is looking at a different table?

Regards

[Missinglinq]

No. If Title is Bound to a Field in the underlying Table, it should be updating.

After you placed this code in your Form, did you go to the Control Source Property for Title and change it from

= Me.Combo819.Column(3)

to

Title

or whatever the actual name of the Field is in the Form's RecordSource?

Linq ;0)>

[Surreall]

Thankyou for replying.

I am confused, if i change the Control Source property for title to

Title

Then when i chose the drop down, the title text box doesnt update with anything?

[Missinglinq]

After you've changed the Control Source to the underlying Field, you'd then have to use the Combobox again to populate the Field on any Records you've already entered. The Textbox was Unbound, so any thing previously entered is gone. It will only write data to the Table after you've set the Control Source to the Title Field.

Linq ;0)>

[Surreall]

Hehe i just get more and more confused lol (really sorry)

I have one drop down box. That is linked to the Customer Tables. That i use to select the company name.
I have another text box, called "Title" that looks at the 3rd column in the combo box above. With this code in the source box, =[Combo819].[column](3).

So when i chose a company name from the drop down box (called company name on the form). The Title box automatically populates itself with the Title of the contact eg "Mr"

But when i save the form the text box that automaticcaly updated with "Mr" (after choosing from the drop down box above it) doesnt save Mr in the table "Jobsheets"

So i tried putting the below code in the Title text box in "after update option"

Private Sub Title_AfterUpdate()
Me.Title = Me.Combo819.Column(3)
End Sub

So when i made your suggestion above in the source code for Title text box. It no longer updates when i chose the drop down in the box above

Does that make sense?

Regards

PS i know i am not explaining well, Access is very very new to me